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 DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.
We believe there is a validation bug in the Flat File Source component. The solution is to set ValidateExternalMetadata=True on the Flat File Source component and set DelayValidation=True on the Data Flow Task Plus.
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
Dynamic Data Flow - How to create completely dynamic data flow?
Starting from 1.4 SR-3 the data flow can be completely dynamic - the need to have one common column across different iteration sets is no longer required. To have completely dynamic components, you have to remove all statically defined columns (both ...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 ...Dynamic Data Flow - Dynamic Column Custom Handler
To setup custom routine in the data flow script for additional setup of dynamically added data flow column, attribute your script main class with DataFlowColumnAdded attribute. Set as parameter the name of the script method. Check below the required ...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 ...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 ...