Post reply

Double pipe as text delimiter

  • December 18, 2003 at 3:59 pm

    #107557

    I need to run some DTS packages that creates flat text files. Everything worked fine, but the client wants double pipe as delimiter. I tested several option but none of them worked. Any suggestions? Any help will be appreciated. Thank you

  • December 18, 2003 at 5:09 pm

    #487117

    I assume you are exporting from a table to a text file using a Transform Data Task. If so, try using Disconnected edit. Set up your connection to your text file using a "vertical bar" as the column delimiter. Then go into Package menu / Disconnected Edit / Connections / YourTextFileConnection / OLE DB Props / Column Delimiter. Set the Value to ||.

  • December 19, 2003 at 8:27 am

    #487229

    Thank you. That did it!!

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

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