MicrosoftHi!
Our team is in the process of testing a server upgrade to SQL Server 2019 (15.0.4013.40 - CU2) in our test environment. To facilitate the testing, I've installed Visual Studio 2019 on my local machine (running parallel with our current version of VS 2017). I then opened an existing solution which retrieves oracle source data, and changed the TargetServerVersion from 2017 to 2019 applying this change to all of the project's packages. The majority of these packages previously relied upon the "Microsoft Connector Version 5.0 for Oracle by Attunity (using SQL Server 2017)", yet I installed the new "Microsoft Connector for Oracle" to comply with the upgrade requirement for SQL Server 2019. With this new driver installed, all the previously built Oracle source components by Attunity transitioned without error to rely upon this new MS Connector. I am able to open these components and preview the oracle source data successfully. However, the problem I am facing involves the execution of these packages. No matter what properties or settings I change (ex. set Run64BitRuntime to either true / false, set DelayValidation to either true / false, etc.), I always encounter the following error on the source component when I execute the package:
[--------] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "------" failed with error code 0xC0014009.
Any suggestions?
