SSIS Text File Destination - Rows not breaking at end of line

  • "Ragged right" feature solved my problem too.

    Thanks for the blog and everyone involved in it ! 🙂

  • I knew the Rugged Right.. but if I change from "Fix Lenth" to "Rugged", I have to reset all 90 columns I am working with.. very painful.. any other suggestion..

  • Yes but it may or may not be quicker depending on your documentation.

    Create a table in SQL server with the data lengths.

    Create a datapump task with a sql source and choose the table you just created.

    Create a destination with a fixed width flat file from within the destination task. Since it is mapped to the table SSIS creates the connection with the data lengths you used for the datatypes.

    Then you can delete the datapump task and reuse the flat file connection.

    Hope that helps.

Viewing 3 posts - 16 through 17 (of 17 total)

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