Convert the pipe delimited file to fixed length file

Who is online?  0 guests and 4 members
Home  »  Forums   »  bidn   »  general bi discussion   » Convert the pipe delimited file to fixed length file

Convert the pipe delimited file to fixed length file

Topic RSS Feed

Posts under the topic: Convert the pipe delimited file to fixed length file

Posted: 10/21/2011

Asmi28
Asmi28
Jedi Youngling 26  points  Jedi Youngling
  • Joined on: 7/7/2011
  • Posts: 13

Hi,

Can anyone guide me how to convert pipe delimeited file to fixed length file.

Help appreciated.

Thanks

Regards

Asmi

Posted: 1/13/2012

MMilligan
MMilligan
Padawan 492  points  Padawan
  • Joined on: 6/7/2011
  • Posts: 41

You can use SSIS to do this.  Create a package with a data flow transformation.  In there, have a Flat File source component that reads the data from the pipe delimited file.  Have it go to a flat file destination using the fixed length file settings.
Page 1 of 1 (2 items)