Post reply

Need help with Text qualifier

  • September 20, 2012 at 1:41 pm

    #264602

    Hello,

    I am trying to export data to CSV file using ssis package..My requirement is i need to have Double quotes(") as my text qualifier..

    Here are my data flow tasks

    1.Source (Select statement)

    2.Data conversions

    3.Csv file connection

    In csv file connection manager i tried adding the text qualifier when ran i dont see the double quotes text qualifier in the file. When i tried doing the same with single quote text qualifier it worked .. Am i missing something here ?

    version:SSIS 2208

    thanks in advance

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • September 21, 2012 at 4:18 am

    #1540561

    Try with 2 'single quotes' as text qualifier instead of double quotes..

    Thanks,

    Arun.

  • September 21, 2012 at 4:58 am

    #1540582

    How are you opening the CSV file after exported with the " character?

    Via Excel, notepad etc?

    If Excel it automatically removes the " as it knows its a text qualifier, open the file in notepad you will see the " in the file.

  • September 21, 2012 at 6:58 am

    #1540655

    Thanks Anthony for the response.. I didnt even think of it

    Arun-- I can use two single quotes and generate a file but the issue with that would be when they are trying to import it they would assume double quote as text qualifier but it wouldnt recognise..

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

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

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