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
Related Articles
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"' ...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"' ...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"' ...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 ...