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.
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)
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!