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

• pshvets

  SSCommitted

  Points: 1850

  More actions

  February 1, 2009 at 1:54 am

  #130648

  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

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  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/

  

• pshvets

  SSCommitted

  Points: 1850

  More actions

  February 1, 2009 at 5:02 pm

  #936211

  Did exactly as you said - works perfectly now.

  Thanks a lot for help!