Monday, February 04, 2013 4:29 PM
I have a simple SSIS package which extracts data from a number of tables using an SP and then outputs the results into a .txt file. My problem is that in one row of about 20000, one column contains line feeds (LFs) in it's contents. If I take a look at the preview of the data, it displays correctly. However upon running the package, the export file contains line feed returns - thereby screwing the layout of the text file and column output in the destination system.
How can I get rid of these line feeds please? I have tried using CR only delimiters but to no success.
Many thanks in advance.
Monday, February 04, 2013 4:43 PMModerator
Just strip the LF using the Derived Column Transformation with SSIS Expression:
Arthur My Blog