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.
- Please check if the query can be tested successfully in SSMS.
- Please check if you change the metadata in sql table.
If yes, please edit the source or destination in Data Flow Task.
- 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”
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.