SSIS package Error - VS_Newmetadata

Question

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 .

Answer 1

Hi @Brijesh S Patel ,

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.

1. Please check if the query can be tested successfully in SSMS.
2. Please check if you change the metadata in sql table.
   If yes, please edit the source or destination in Data Flow Task.
3. Please refer to the following links:
   a. SSIS Error: VS_NEEDSNEWMETADATA
   b. SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.