question

BrijeshSPatel-6918 avatar image
0 Votes"
BrijeshSPatel-6918 asked Monalv-msft edited

SSIS package Error - VS_Newmetadata

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 .

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @BrijeshSPatel-6918 ,

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.



· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

  • Query is tested successfully when view is clicked it shows me the DB name and System date as expected .

  • There is no changes in metadata in sql table , only change happening is changing the underlying DB to be pointed to a different environment I.E Dkmxpja represents DV server and Ukmxpja represents UA server . Checked the Source and destination of the Data flow task. Everything seems to be in order. No pop up to update the Metadata.

  • I have tried the solution in first link provided already . For some reason the property ValidateExternalMetada does not stay false even after setting it to false and deploying . It changes back to True if I change the underlying connection to different Server .

  • Also tried the DTExec command to check the Verbose logs . It does not give any other exception other than " VS_NEEDSNEWMETADATA".


0 Votes 0 ·

Hi @BrijeshSPatel-6918 ,

The package throws an error " "Oracle_SRC_METADATA" Failed validation and returned validation status " VS_NEEDSNEWMETADATA" .

Please create new task , source or destination , connection in ssis package.

Best Regards,
Mona

1 Vote 1 ·

OK , I shall try that.

0 Votes 0 ·
Show more comments