November 11, 2010 at 10:27 am
Hi,
I have a for each loop , which executes 3 packages in a sequence. I am having issues while executing the third package.
It says "component failed validation and returned validation status "VS_NEEDSNEWMETADATA".
When I run disable the third package and run it, it runs withot any error.
When I run the third package separately, it executes with out any error. I am at loss as I am unable to know the cause of the error since packages run with out any error when run independently.
November 12, 2010 at 3:22 am
The NEEDS NEW METADATA notification usually occurs when the package is not synchronized with the database structure (probably missing columns or varying datatypes/column width for certain fields). Check in the OLEDB connection the DBName if it is the same in the parent package to that of the child package which is failing at runtime, probably it's not. I guess this is the cause due to the fact that when executed alone the failing package runs successfully meaning that it is in conformity with the DB structure. If this is the case you either have to do some changes in your DB or in the package itself to resolve the issue.
Regards,
Samer.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply