Post reply

Adding CRLF in SSIS for fixed width output files

  • April 18, 2014 at 1:49 pm

    #290416

    First create a derived column as string. Set the expression to "\r".

    In Connection Manager edit the flatfile connection.

    Select Advanced and add a new column, i.e. CRLF, set it as a string, 2 bytes.

    Save and run your package.

    You should have output on each line.

  • April 18, 2014 at 3:44 pm

    #1707208

    What is your question?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply