Home Forums Data Warehousing Integration Services SSIS Flat File Destination Formatting to add a carriage return RE: SSIS Flat File Destination Formatting to add a carriage return

  • November 26, 2012 at 12:07 pm

    #1562356

    kwoznica (11/26/2012)

    I have as that was the default. I changed a few different options but they did not take effect. what other way can you create a carriage return?

    I would guess that you only have a LF (ASCII Char(10)) as opposed to CR LF (ASCII Char(10) + ASCII Char(13)). But rather than going on my guess, open the source file in an editor that can display the end of line characters (Vim or NotePad++ as well as month others editors can).

    Take a look and see if that helps,

    Rob