Importing csv file using SSIS package in sql server 2005

Hi,
I am creating an SSIS package in sql server 2005 which imports a csv file into a database table.
I am using a “Flat File Source” to connect  to the csv file. (see sample from csv file)
The problem is that that the file groups an address using “ “ but SSIS sees each comma as a new column. This results in the output displayed below.
Any advice on how to resolve this appreciated. Thanks
 flat file
blossomparkAsked:
Who is Participating?
 
blossomparkConnect With a Mentor Author Commented:
Hi,
 found the answer in this article
http://www.mssqltips.com/sqlservertip/1316/strip-double-quotes-from-an-import-file-in-integration-services-ssis/
put text qualifier as " and now works...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.