SSIS Redirect Rows - Blank Rows created

  • Hello,

    I am using the "Redirect Row" option for any rows that error out. The step is working correctly. The errored rows are being redirected as expected.

    However, the output file populated with the errored rows is being created with a blank row between each errored row. There are no blank rows in the source file, which is a .txt file.

    Any suggestions?

    Thanks!

  • The flat file connection manager for the error file, what is it's row delimiter?

    What are you using to view the error file?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi,

    I also face the same issue where errored rows is being created with a blank row between each errored row.

    My Source file is Comma separated CSV file.

    I am re-directing the Error output to another FlatFile (csv). In the Error output, i see the following 3 columns :

    Flat File Source Error Output Column , ErrorCode, ErrorColumn.

    During the FlatFile Conn Manager setup for Error File, i just retain only one column "Flat File Source Error Output Column".

    Even after this, i get a blank row between each errored row.

    Appreciate your help to resolve this blank row issue.

    Thanks,

    Arun

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

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