Log Parser 2.2: select some columns from CSV (with no column names) into SQL

Hi all,

I have a problem with Log Parser 2.2 and CSV files I hope you can help me with. I have some CSV log files which unfortunately have no column names, but I only want to select certain columns from the CSV to insert into SQL. Is there a way around this? If there were column names, I'd be able to do: select col1, col3, col9 etc, but as they don't exist, is there another way (like select 1,2,3)?

Thanks

Jon
LVL 11
Jon WinterburnAsked:
Who is Participating?
 
Ted BouskillConnect With a Mentor Senior Software DeveloperCommented:
You can solve this with the same answer I gave you on your other question! Once again the Schema.ini can control column names.

http://msdn2.microsoft.com/en-us/library/ms709353.aspx
0
All Courses

From novice to tech pro — start learning today.