ronan.healy (8/5/2014)
its not a single column there is 20 columns in the file. I can see why its causing the error. on the column delimiter its set to comma(,)
if I try anything else it doesn't bring back any data. is there any way around this
It seems your csv file is not a great csv file.
If the 20 columns are seperated by commas, there should be no commas in the data itself, unless they use a text delimiter at the start and end of each text column.
Just changing the delimiter in SSIS won't help. You need to change the actual format of the file.