I have scenario where I am extracting data from excel(Source) and want to extract error records in the same format.
My package flow is extract Source data (Excel) > into Staging table (SQL) > Run Validation Script > extract only invalid rows (Excel).
Fix invalid rows > and again run the package.
I have designed the package. the problem I facing is when i extract invalid rows and try to run the package again I get "VS_NEEDMETADATA" message which basically looks for refreshing source file meta data.
I want to extract the invalid rows with same metadata as source file. so when I run the package again using invalid rows file it should wor,
please help!
Abhijit - http://abhijitmore.wordpress.com