SSIS: How To Strip Double Quotes ” From .csv File on Import

February 20th, 2012

This is a quick tutorial to show you how to strip/remove the double quotes ” from columns in a .csv file when importing with SSIS (SQL Server Integration Services).

I like to use the wizard, since it’s quick and easy.

1. Right-click SSIS Packages in your Solution Explorer.
2. Select SSIS Import and Export Wizard.

3. When the SQL Server Import and Export Wizard comes up change the Data Source to Flat File Source.
4. Select your file name by hitting Browse.
5. Under Format you need to change the Text qualifier from <none>  to (double quotes):

(Note: I have checked Column names in the first data row because my .csv file has the column names. Do not check this if your file does not have the column names)

6. Now if you click on Preview you will see your columns without the (double quotes):

7. Now you can hit Next on the wizard and choose your Destination Connection and follow through how you normally would.

It’s really just that simple!

Related posts:

3 Responses to “SSIS: How To Strip Double Quotes ” From .csv File on Import”

  1. GweNerD says:

    5. Under Format you need to change the Text qualifier from to “ (double quotes)
    -
    is there missing something behind “from” word or is problem in me? :)

  2. Amy says:

    You are right, it was supposed to say , I fixed it! Thanks so much for pointing it out :)

RSS feed for comments on this post. And trackBack URL.

Leave a Reply