SSIS error VS_NEEDSNEWMETADATA

Mr_Shaw
Mr_Shaw used Ask the Experts™
on
I have just run my SSIS package through SQL Agent and recieved the following error.

"component "Schedules01" (426)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".  End Error  Error: 2009-05-24 04:16:10.30     Code: 0xC004700C     Source: AllSchedules DTS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2009-05-24 04:16:10.32     Code: 0xC0024107     Source: AllSchedules      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  04:15:12  Finished: 04:16:10  Elapsed:  58.828 seconds.  The package execution failed.  The step failed.

I am not sure what it all means. Can anybody help?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
do you change the fields in source or destination? like type, lenght, name...

Regards,
Pedro
www.pedrocgd.blogspot.com
www.BIResort.net

Author

Commented:
Yes, I add an extra column.

Author

Commented:
in the source
Commented:
open the package again... and go to source or destination components inside dataflow... open, go to mappings and close... is only to refresh the metadata of the components that were using the table that you changed... understood?
regards,
Pedro

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial