Log Parser 2.2: data type is not compatible with SELECT clause
Posted on 2008-01-30
I have a problem with Log Parser 2.2 and CSV files I hope you can help me with. When run log parser against my CSV files, I get the following error:
SQL table column "Originator" data type is not compatible with SELECT clause item "ORIGINATOR" (type INTEGER)
Now the SQL table column called "Originator" is set up as a varchar, because the CSV column called "ORIGINATOR" could contain either numbers or letters (though most often numbers). Log parser thinks that this column is an integer because the first log it analyses only contains numbers, but subsequent logs will contain both numbers and letters.
Therefore, if I change my SQL column data type to integer, subsequent logs will fail saying the data type is wrong again!
Surely there must be a way with Log Parser to tell it to simply take the CSV columns and ignore their data type and just insert their values into the SQL table?