Home Forums SQL Server 2014 Development - SQL Server 2014 Extract to CSV File RE: Extract to CSV File

  • October 17, 2017 at 7:14 pm

    #1964132

    wweraw25 - Tuesday, October 17, 2017 6:04 PM

    I have data something like below for one of the column.

    ADDRESS
    2248|("snake") ft NE, FTE 700

    When I extract this record to csv using SSIS, My column is populating as below:

    ADDRESS                              Some other column
    2248|("snake") ft NE                FTE 700

    I've used something like this in my ole db source
    Select '"'+[Address]+'"' from dbo.table

    I'm not really grasping what the question is here.

    Ah... now I see it.  I had to be in the edit mode of this post in order to see that the "FTE 700" part of the address ended up in another column.  I also see that this is for SSIS, which I know nothing about and so I can't help here but, hopefully, my post will also act as a clarification and a "bump" for those that do know about SSIS.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)