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.




   

- Advertisement -