Importing csv file using SSIS package in sql server 2005

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
Who is Participating?
blossomparkConnect With a Mentor Author Commented:
 found the answer in this article
put text qualifier as " and now works...
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.