I have been using SSIS package to get data from SQL server Database . One of the queries being used is Select Ora_database_name as Database, to_char(SYSDATE,'YYYY-MM-HH24:MI:SS') as SCRIPT_RUN_DATE FROM Dual. Whenever there is a change in the environment while running the job for this package, The package throws an error " "Oracle_SRC_METADATA" Failed validation and returned validation status " VS_NEEDSNEWMETADATA" . "Oracle_SRC_METADATA" is the name of the shape which has the above mentioned query. Once I open the shape and check the view and run again , it runs without error . Any Idea how do I fix this ? Happens when Switching the Environment where it runs .