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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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