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 Editor2) Go to the 'Dynamic' tab options3) Set both properties ErrorRowDisposition and TruncationRow Disposition to RD_IgnoreFailureKeep 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+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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 ...Dynamic Data Flow - "... is DT_NTEXT, which is not supported with ANSI files" when trying to process input Unicode flat file
Trying to process input Unicode flat file fails with weird error: The data type for "Flat File Source.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]" is DT_NTEXT, which is not supported with ANSI files. Use ...DataFlowSetting .NET attribute used with Data Flow Task Plus
The DataFlowSetting .NET attribute defines a list of references to different component properties in the SSIS data flow. It defines the link between the initialization parameter and a specific SSIS data flow component parameter. You can apply one ...Dynamic Flat File Import uses wrong THUNK_COLUMN length.
Issue: It appears that the column length is being picked up from whatever we set the THUNK_COLUMN length against the Flat File Connection manager rather than the destination table individual column length's. Solution: Set the THUNK_COLUMN column type ...Error Message: Flexible File Source failed validation and returned validation status VS_NEEDSNEWMETADATA
Action: While executing a package that uses Azure Flexible File Source in a Data Flow Task Plus, the following error message is received. Error Message: '"Flexible File Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA"' ...