Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to extract data into a pipe delimited flat file in SSIS RE: How to extract data into a pipe delimited flat file in SSIS

  • February 1, 2009 at 8:36 am

    #936159

    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/