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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 VS_NEEDSNEWMETADATA
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

pointer
Starting Member

India
2 Posts

Posted - 05/21/2015 :  07:43:12  Show Profile  Reply with Quote
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.




   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000