Post reply

Load Flat File from SQl Server with double quotation marks

  • May 24, 2010 at 3:05 pm

    #232861

    I have a data flow task and the entire process is quite simple where i am loading a flat file from an OLEDB source. The problem is that i want the columns wrapped with double quotation marks. Is there any way i can specify this in the flat file connection manager. Or is there any other solution for this?

  • May 25, 2010 at 2:18 am

    #1171913

    I don't believe it is possible to do it right away in the Flat File Source.

    However, you can add a derived column component to add the doubel quotes:

    "\" + MyColumn + "\" (I assume your columns are all string data types)

    If you have too many columns and it is too tiresome to configure them all with the derived column, then you could consider using a script component to read your flat file.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply