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!
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/