Saturday, August 11, 2007 3:58 PMHi guys, wonder if you could help.
Ok, basically, my SSIS flow gets data from different excel worksheets and puts in the db.
For some reason its being very incosistent. I fixed all the problems I was having but one component keeps coming up with the [ component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA" ] error.
So, I click on the component, it asks if i want to fix the metadata stuff, I say yes, it fixes it, I run the app, everything's cool.
The I run the app again and again it comes up with this f** error?
Is there anyway SSIS can't just ignore this metadata stuff??
Saturday, August 11, 2007 5:24 PM
You cannot ignore metadata, that is how SSIS understand the columns, its data types etc.,
If you are using same source connection in the Data Flow Task and your source excel file keeps chaning, then everytime you change the excel file you need to refresh the metadata.
If your number of excel inputs are consistent (say 4 excel files), then create 4 seperate transformations for each excel file, so that you will not have to refresh the metadata again and again.
Other option could be using a script task to programatically create the source , destination and mappings. Refer the below link for that, it will give you an idea.
Saturday, August 11, 2007 5:33 PMyeah, excel files not consistent. But yeah, great idea on the script componets, cheers!!
- Proposed As Answer by alessandro .valsasina Wednesday, May 05, 2010 9:04 PM
Saturday, August 11, 2007 6:25 PM
If your number of sources is consistent, it is easier to add few more transformations to the package than going through the process of doing things in the programmatic way (or call me lazy )
Wednesday, May 05, 2010 9:08 PM
yeah, file di Excel non è coerente. Ma sì, grande idea sul componets script, cheers!
Ho cliccato,erroneamente su "PROPONE COME RISPOSTA" non considerarla valida OK