Error Message: The ODBC Source.Outputs ODBC Source Output.Columns THUNK_COLUMN has an invalid error or truncation row disposition.

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

Action:
When executing a package using Data Flow Task Plus withing a Foreach Loop and an ODBC Source, the first iteration of the loop succeeds, followed by the following error message on the second iteration of the loop.
Error Message:
'The ODBC Source.Outputs[ODBC 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, within the Data Flow Task Editor's 'Dynamic' tab options, the change ErrorRowDisposition and TruncationRow Disposition from the default RD_IgnoreFailure to RD_NotUsed


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