SSIS Flat File Data Source - Comma delimited file where rows contain commas

Peter Schmitz

Staff member
Today, I had to source some csv files. So I set up a Flat File Connection Manager object, and configured it to deal with my file. The row delimiter was set to "Comma {,}", to fit the format of the source file.

However, as it turns out, a number of the rows contained fields where end users added commas in the field (for example an address). In these cases, the data for that column was surrounded with double quotes (").

Luckily, the SSIS Flat File Connection Manager allows you to deal with that easily. The "Text Qualifier" propert is exactly intended for that purpose. Setting that to a double quote pretty much solved the issue and ensured that my data preview looks correct: