Post reply

Text Qualifier in DTS

  • November 19, 2004 at 1:15 pm

    #84262

    I have a DTS package that loads a sequential file to a table.  I have had the load fail when the input data contained double quotes.  I can resolve the problem by changing the 'text qualifier' for the input file from double quotes to <none>.

    Are there any negative implications for changing that 'text qualifier'?  It seems to solve the problem nicely.  Thanks

  • November 19, 2004 at 4:03 pm

    #530919

    If the data itself does not have a text qualifier then it will not affect you. If it does then you will end up reading in the text qualifier as part of the text, but it seems in your case double quote would make a bad qualifier anyway.

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

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