Post reply

Trouble creating a text file that columns that contain double quotes

  • February 7, 2007 at 3:05 pm

    #115511

    I had a DTS package that was very simple and just created a text output file from a table.  I converted the DTS package to SSIS using the import package wizzard.  It all works except...

    DTS version is puts out a row like this...

    "0","0","DESC AS AUDITOR'S PARCEL ""A"" IN SURVEY"

    The SSIS version is this...

    "0","0","DESC AS AUDITOR'S PARCEL "A" IN SURVEY"

    As you see the double quotes around A were doubled up in DTS but not SSIS.  Is there a property that I can change that will make SSIS export the data to the flat file with the extra quotes?  This is causing a problem for a downstream user and will need to continue to use the DTS package until I can resolve this problem.

    Thanks

  • February 8, 2007 at 3:11 pm

    #688684

    Any ideas?  I said it was text output but it is really a CSV file (comma delimited and double quote text qualifier).  Even Excel does not open file correctly.  It looses the second double quote within the text then the ending double quote shows up at the end of th line.
     
    Thanks

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

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