Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajnidas
Yak Posting Veteran
97 Posts |
 Posted - 2013-12-07 : 06:07:27
|
| Hi every one,i am getting following error when i upload execution ssis package from C# (asp.net) code :"Excel Destination Data Error Sheet" failed validation and returned validation status "VS_NEEDSNEWMETADATA". One or more component failed validation. There were errors during task validation.i need help asapThanks rajnidas |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-07 : 08:34:52
|
| This means the file structure (matadata) has some mismatch with columns thats coming from the source. Open the package in BIDS and see file structure set inside and make sure its same as columns you get from the source.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
rajnidas
Yak Posting Veteran
97 Posts |
Posted - 2013-12-09 : 05:38:50
|
| Thanks visakh murukes sir,The SSIS package is working now. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-09 : 06:44:42
|
| cool------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssis package execution issue