Error Message: The Flat File Source.Outputs[Flat File Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition.

Error Message: The Flat File Source.Outputs[Flat File Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition.

Action:
When executing a package using Data Flow Task Plus within a Foreach Loop and a Flat File Source, the first iteration of the loop succeeds, followed by the following error message on the second iteration of the loop.
Error Message:
''The Flat File Source.Outputs[Flat File Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition."
Solution:

To avoid error message produced on second iteration of Foreach Loop follow the steps below:

1) Go to Data Flow Plus Task Editor
2) Go to the 'Dynamic' tab options
3) Set both properties ErrorRowDisposition and TruncationRow Disposition to RD_IgnoreFailure 
Keep in mind that option RD_NotUsed should not be used for the Flat File Source component in Data Flow Task Plus, because it is an invalid error/truncation disposition for the Flat File Source component.
      

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.