time to read 1 min | 94 words

Another team have run into this bug, what this basically means is that SSIS is not capable of importing CSV files. The "spec" for CSV files is about three lines long, including the special cases ( of which there are two ) and it hasn't changed in a decade.

It boggles the mind that not only isn't SSIS capable of doing this, but they are not going to fix it for SSIS 2008. Looks like you would need to wait to SSIS 201x for a version that can handle CSV files.