How to add quotes to string at SSIS level

  • Hi all,

    I have string say preen,preen I need to replace it with "preen,preen". So that when I load the data to CSV. the name will be in same column rather than gng to 2 different columns.

    Please Advice

  • Specify " as your text qualifier in your flat file destination connection manager.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Phil Parkin (10/6/2010)


    Specify " as your text qualifier in your flat file destination connection manager.

    hey thanks a lot for the fast response, it worked out for me.:-D:-)

  • Great - thanks for posting back.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

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