Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to extract data into a pipe delimited flat file in SSIS Expand / Collapse
Author
Message
Posted Sunday, February 1, 2009 1:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 18, 2011 10:54 AM
Points: 54, Visits: 154
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
Post #647668
Posted Sunday, February 1, 2009 8:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:17 PM
Points: 1,118, Visits: 2,224
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/

Post #647709
Posted Sunday, February 1, 2009 5:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 18, 2011 10:54 AM
Points: 54, Visits: 154
Did exactly as you said - works perfectly now.
Thanks a lot for help!
Post #647764
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse