CODEWITHSUNDEEP
ssisssi
Rasika Ogale
Rasika Ogale

Reputation: 41

SSIS Error : [SSIS.Pipeline] Error: "component "Excel Source" (14)" failed validation and returned validation status "VS_NEEDSNEWMETADATA"

I've gone through this URL:

How to loop through Excel files and load them into a database using SSIS package

And I followed the same steps mentioned there but I got this warning:

[Excel Source [14]] Warning: The external columns for component 
"Excel Source" (14) are out of synchronization with the data source 
columns. The column "state" needs to be added to the external columns.
The external column "state " (27) needs to be removed from the external 
columns.

and this error: 

[SSIS.Pipeline] Error: "component "Excel Source" (14)" failed validation 
and returned    validation status "VS_NEEDSNEWMETADATA".

Upvotes: 4

Views: 29110

Answers (6)

ia_lp
ia_lp

Reputation: 11

The column's name is different. You have a space in de the name "state" vs "state ". And it's case sensitive too.

Upvotes: 1

sachin sapkal
sachin sapkal

Reputation: 21

The reason for this error is change in metadata, in my case a column name was renamed in Excel source. Verify the Excel column names and respective mapping.

Upvotes: 2

knkarthick24
knkarthick24

Reputation: 3216

This happens when you change the excel which you predefined in your connection manager during development. If you want to change the excel, make sure you do the changes in excel connection manager too(though you have configured to make use of other names).

Upvotes: 0

Vijay
Vijay

Reputation: 9

Remove the unused or blank excel sheets from excel source and try to execute the package again.

Upvotes: 0

Maverick
Maverick

Reputation: 1185

There is problem with excel source when you are working on it. There are some steps to avoid it: 1) make sure you get the Excel connection and do not change the excel file connection string or folder( physically don't move the file) 2) Check the Red Cross (X), if you see that locate the arrow in excel file source and it will show you the error code. 3) Open the excel source and check the column and check the preview 4) click ok

Note: you should not have Red Cross(X)

Upvotes: 1

ichauvin
ichauvin

Reputation: 240

I have found with this error, it is sometimes fixed by simply double clicking on each of the components, viewing the columns and various transformations, then pressing OK. I then save and re-run and it works. Make sure no red x's are lingering around or any other warnings.

Upvotes: 4

Related Questions