How are you running this?

Question

User531388329 posted

Just starting to play around with the command line, but I'd rather put it in a script, perhaps call from VB front end or create a scheduled job.

I thought I could put the command in a sepearate file and launch it with "logparser -file=filename.txt", but that doesn't appear to work. Maybe I'm doing something wrong there?

How are you using LogParser?

Answer 1

User531388329 posted

You have to use a colon to make it work:

logparser -file:filename.txt

but filename.txt can only contain the SQL query...you still have to provide the switches on the command-line:

logparser -file:filename.txt -i:IISW3C -o:SQL -database:mydatabase etc...

BTW, if you want to use VB, consider using the logparser COM objects.