Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Problem with row containing Line Feeds

Answered Problem with row containing Line Feeds

  • Monday, February 04, 2013 4:29 PM
     
     
    Sign In to Vote
    0

    Hi all

    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.

     

All Replies