Reading .csv file

[burakcan]

Hi All,

I have a .csv file (, separated) which I read into the SQL server, but there is a value like "Manitoulin, Unorganized, West Part". Because of the ,s in the value SSIS put each word into next field.
Is there any way to put whole value into the one field?

Thanks

 

[micang]

Does your csv have " (double apostrophe) around the fields? If so, set your text qualifier to " (double apostrophe) for your flat file source.

Thanks
Michael