SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 ssis package execution issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rajnidas
Yak Posting Veteran

India
72 Posts

Posted - 12/07/2013 :  06:07:27  Show Profile  Reply with Quote
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 asap

Thanks
rajnidas

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/07/2013 :  08:34:52  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

rajnidas
Yak Posting Veteran

India
72 Posts

Posted - 12/09/2013 :  05:38:50  Show Profile  Reply with Quote
Thanks visakh murukes sir,

The SSIS package is working now.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/09/2013 :  06:44:42  Show Profile  Reply with Quote
cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000