How to extract data into a pipe delimited flat file in SSIS

  • Hello folks,

    I need to extract the data into a pipe delimited flat file.

    There seems to be no option in SSIS 2005/8 for doing so.

    Thanks in advance!

    Pit

  • pshvets (2/1/2009)


    Hello folks,

    I need to extract the data into a pipe delimited flat file.

    There seems to be no option in SSIS 2005/8 for doing so.

    Thanks in advance!

    Pit

    Pit,

    You have to setup flat file connection manager. In it, you can specify in the "Columns" section, a row delimiter to be Vertical Bar (I). I hope this is what you mean by pipe delimited file. After this you have to create a data flow task and direct your data to flat file destination component.

    Give it a try and let us know how it goes.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • Did exactly as you said - works perfectly now.

    Thanks a lot for help!

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

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