Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  VS_NEEDSNEWMETADATA

Author  Topic  pointer Starting Member 2 Posts Posted - 2015-05-21 : 07:43:12 Hi, I have tried to import 3 different .xlsx file with different schema dynamically. And i got the error Error: 0xC004706B at Data Flow Task, SSIS.Pipeline: "component "Excel Source" (43)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". What i have done is, 1.created 3 variable a)MaskName = .xlsx b)FolderPath = C:\Srcc)FilePath = C:\Src\Class.xlsx 2. Configured Foreach Loop enumerator = Foreach File Enumerator Folder = C:\Src\Class.xlsx files : = *.xlsx and varibale mapping = [User::FilePath] 3.Also have DFT and Derived column (only to test what data is coming)in which I have a)Excel source which is connected to Excel connection manager Connection Manager, Excel file path = C:\Src\Class.xlsx Property : ExcelFilePath = [User::FilePath] Excel Source Editor : OLDB Connection = Excel connection manager Data access mode = Table or view Name of excel sheet = Sheet1$. When i am running my package, for the first file class.xlsx it running file, but when ForEach loop come on the second file lets say map.xlsx(which has different schema than class.xlsx) it start giving error : Error: 0xC004706B at Data Flow Task, SSIS.Pipeline: "component "Excel Source" (43)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. Please help, how to come off this error.