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

ssis ssi
Rasika Ogale picture Rasika Ogale · Apr 8, 2013 · Viewed 20.4k times · Source

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".

Answer

ichauvin picture ichauvin · Apr 19, 2013

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.

Related questions

How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet …

Read More
What is the SSIS package and what does it do?

Can someone tell me what the SSIS package is all about? I am totally new to data-warehousing and I am going crazy with the terms SSIS, DTL, ETL and so on. I am looking for a big picture and how …

Read More