I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 2019 database. I'm using Oracle connection (Connection Manager for Oracle Connections) for my source and an OLE DB connection for my SQL 2019 database. Test connection work fine for both and when I execute the package in VS2019, it works fine.
When I deploy it to SQL2019 and run it from a agent job, I get a DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error. I have seen some forums and done following changes,
In VS2019 Run64BitRuntime to false
In agent job, checked it to run in 32bit mode.
Installed MicrosoftSSISOracleConnector on the server containing SQL2019
Tired by setting DTS property to EncryptSensitiveWithUserKey and with password too.
Also tried DelayValidation with True and with False.
But no joy so far. Has anyone troubleshooted this in past and can shed some light on this please?
- This topic was modified 1 week, 5 days ago by BIDeveloper.