I had this question after viewing SSIS error VS_NEEDSNEWMETADATA
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 tried below solution :
deleted the data source and recreated it.
refresh the mapping
recreated the whole task
I am not sure what it all means. Can anybody help?