June 27, 2008 at 12:12 pm
Hello fellow professional. I am converting data from an Informix database to a SQL Server 2005 database using SSIS. It works beautifully with one minor detail. The Informix High Speed Unloader generates pipe delimited files and puts a pipe (|) on the end of each line as well. This pipe is getting loaded into the database along with the data. I would like to remove this last pipe prior to inserting the data into the database using my SSIS package. Can someone kindly guide me on how to accomplish this? Thank you.
-David
Best Regards,
~David
June 27, 2008 at 12:45 pm
So you are getting a file with pipe delimiters between fields and a CRLF for row delimiters.
If you are getting an extra pipe at the end of the line, make the row delimiter {|}{CR}{LF} rather than {CR}{LF}.
June 27, 2008 at 1:50 pm
Michael, that works perfect!
Easy solution. Thank you very much.
-David
Best Regards,
~David
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply