Importing csv file using SSIS package in sql server 2005

Posted on 2011-10-19
Last Modified: 2012-05-12
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
Question by:blossompark
    1 Comment

    Accepted Solution

     found the answer in this article
    put text qualifier as " and now works...

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now