I'm using logparser to parse IIS logs. But i get an error like this. What is the problemm?
C:\Program Files\Log Parser 2.2>LogParser "SELECT * INTO MyTable FROM C:\logfile.log"
-i:TEXTWORD -o:SQL -server:NOTEBOOK -database:Log -driver:"SQL Server" -createT
able:ON -fixColNames:ON
Task aborted.
Error creating table
SQL State: 42000
Native Error: 1018
Error Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect
syntax near 'Index'. If this is intended as a part of a table hint, A WITH
keyword and parenthesis are now required. See SQL Server Books Online for
proper syntax.
Most likely you're attempting to create a table with invalid column names,
such as names containing the '-' character, or names that are illegal for
the database you are connecting to (e.g. 'timestamp'). Rename the columns
in the SELECT clause using the AS statement.
Statistics:
-----------
Elements processed: 0
Elements output: 0
Execution time: 0.05 seconds
Doygun
1 Post
Error creating table
Feb 26, 2013 08:23 PM|LINK
I'm using logparser to parse IIS logs. But i get an error like this. What is the problemm?