Error Message: Flexible File Source failed validation and returned validation status VS_NEEDSNEWMETADATA
While executing a package that uses Azure Flexible File Source in a Data Flow Task Plus, the following error message is received.
'"Flexible File Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA"'
There appears to be a bug in the Azure Flexible File Source component. COZYROC has concluded that the Flexible Source component has a bug where ValidateExternalMetadata property is ignored and the component always validates. The only way to resolve this issue is to contact Microsoft support and ask them to fix their component to follow the SSIS guidelines.
Customers are encouraged to up-vote the following bug report for Microsoft to consider fixing the issue.
If you want to process CSV data from Azure, first download the file locally. Then use the standard Flat File component to process the data.
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 - "... 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 ...
Error Message: "Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies”
Action: While using the OLE DB Destination inside of Data Flow Task Plus, the following error is encountered. Error Message: “Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its ...
Data Flow Task Plus editor doesn't open
When I double-click on Data Flow Task Plus, the Data Flow Task Plus Editor doesn't open and instead of that I am sent to the Data Flow tab. There is a known issue in Visual Studio when a solution file is opened externally (e.g. from the taskbar ...
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 ...