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"'
Conclusion:
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.Bug report:
Workaround:
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.
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 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
Action: When I click twice on Data Flow Task Plus Component I get the following error: Error: Data Flow Task Plus' Editor doesn't open and instead of the I get the control flow tab. Solution: To solve the issue you should complete the steps below: ...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 ...