Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

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

Discussion in 'SQL Server Scripts and Tools' started by Peter Schmitz, Feb 3, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator 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:

    upload_2017-2-3_15-3-3.png

Share This Page