Comma within fields in CSV file -import to DB using SSIS

csv ssis comma
Murali Uppangala picture Murali Uppangala · Apr 25, 2014 · Viewed 29.9k times · Source

I have a CSV file - It has many values having comma as a part of value.The commas within the fields will mislead my SSIS package to understand that file row has more columns than previously said!

How to resolve this?

Eg:

Name,Amount,Address

Me,20,000,My Home,India

you,23,300,Your Home,Where

here only 3 columns exist but SSIS assumes all commas used to separate fields;Actually not all.Amount Column and Address Column have extra commas.

Answer

sakshi jain picture sakshi jain · Oct 29, 2015

Use Text Qualifier in Flat file Connection Manager as ". This will separate only values out of quotes by commas. Your data from db will be enclosed in quotes.

Related questions

What SSIS "error code 0xC0202092" means? (DTS_E_PRIMEOUTPUTFAILED)

Here it is below a full dump of the SSIS complains. Please note that I imported the same data in the destination table by using a different tool already and everything is looking perfectly, I suppose that means the schema …

Read More
SSIS: Code page goes back to 65001

In an SSIS package that I'm writing, I have a CSV file as a source. On the Connection Manager General page, it has 65001 as the Code page (I was testing something). Unicode is not checked. The columns map to a …

Read More
SSIS is executing successfully, but it doesn't seem to be running the script task portion

I have an SSIS package that runs an SQL query and exports it to a csv file via a Data Flow Task. After the csv is created, I have a "Script Task" set to connect to an SMTP server and …

Read More