Adding CRLF in SSIS for fixed width output files

  • 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.

  • 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