2. května 2012 7:58
I am facing an issue with the load of excel file with multiple sheets.
Here is the link with i followed to do this:
It is getting executed for the first sheet but from the second sheet on it is failing with the below error:
[SSIS.Pipeline] Error: "component "Excel Source" (37)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
[Excel Source ] Warning: The external columns for component "Excel Source" (37) are out of synchronization with the data source columns. The column "F1" needs to be added to the external columns.
The external column "Capital" (76) needs to be removed from the external columns.
The external column "State" (73) needs to be removed from the external columns.
Thanks in advance,Eshwar.
2. května 2012 8:35
That will only work if all sheets have the exact same columns.
I guess this is not the case.
If your metadata is dynamic, you need to create a dataflow for each Excel sheet.
- Označen jako odpověď Todd McDermidMVP, Moderator 2. května 2012 17:05
2. května 2012 11:05
You might be mis-matching the columns of different sheet. Please check and verify once that you are not having such basic issues.
While, you can also check URL,
Revert if prblm still persists..!!
Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com
2. května 2012 11:35
Thanks for the reply..
the column name of all the sheet are same.
2. května 2012 11:40
2. května 2012 12:21
yeah i am sure both the names are same i recreated the file and copied the same name from the first sheet. Am i missing anything else?
2. května 2012 12:23
sorry it is working there is blank sheet that was causing the issue.