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

Question

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 1

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.

Answer 2

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.