SQL job fails while inserting records to Oracle db
Hi,
We have created SSIS package for inserting some of the table records from SQL server database to Oracle database. To insert the records we have created custom script and automated it has SQL agent and it is working fine for quite few months. But for last 1 week we are getting error unable to acquire connection.
Tried the below steps:
1. Both ports are opened in oracle and SQL.
2. Tested connectivity and was working fine.
3. Tried by creating a export data task from SQL database and run with the custom script to insert data and it worked fine.
Only SQL agent job the data is not transferring and getting unable to acquire connection.
SQL version : 2019 RTM CU-25 Enterprise edition.
Can someone please help on this.
Thanks,
Sujay
Hi, We have created SSIS package for inserting some of the table records from SQL server database to Oracle database. To insert the records we have created custom script and automated it has SQL agent and it is working fine for quite few months. But for last 1 week we are getting error unable to acquire connection. Tried the below steps:1. Both ports are opened in oracle and SQL.2. Tested connectivity and was working fine.3. Tried by creating a export data task from SQL database and run with the custom script to insert data and it worked fine.Only SQL agent job the data is not transferring and getting unable to acquire connection.SQL version : 2019 RTM CU-25 Enterprise edition.Can someone please help on this. Thanks,Sujay Read More