Dynamic Data Flow - "... is DT_NTEXT, which is not supported with ANSI files" when trying to process input Unicode flat file

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