This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have upgraded a SSIS solution from Visual Studio 2013 using Attunity component for Oracle to :
Visual Studio 2019 Version 16.7.4
SSIS extension : 3.10
Targeted server version for Deployment : 2019 . ( I have also tried 2017 and have installed Microsoft Connectors v.5.0 for Oracle both 86 and 64).
After the upgrade ( cloning the solution from git and loading in VS 2019)
if the Microsoft Connector for Oracle V 1.0 is not installed then the Microsoft Connection Manager for Oracle can not be loaded and fails with :
Microsoft Visual Studio is unable to load the document.
Unable to create the type with the name 'DTS.ConnectionManagerOracle.1'
I had to install the Microsoft Connector for Oracle V 1.0 otherwise the ssis packages failed to load . The error : Microsoft Visual Studio is unable to load the document. Object reference not set to an instance of an object.
When using the Oracle provider for OLE DB, the test of the connection succeeds.
When using the MS Oracle Connection Manager it fails to establish the connection and the message error is:
There was an error trying to establish an Oracle connection with the database server.
As a consequence , when using the MS Oracle Source component it always fails with the error :
There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
Error at XXXXX: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "MSORA" failed with error code 0xC0014009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error at XXXX [SSIS.Pipeline]: V_ADV_TRANS_NI failed validation and returned error code 0xC020801C.
I've tried installing and unistalling of the connectors several times but nothing helps.
Thank you very much for any ideas that can help me solving this issue, as I'm really under pressure.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Anonymous ,
Please check my answer here: oracle-connector-is-not-working-in-both-vs2017-and.html
If you are targeting SQL Server 2019 Enterprise edition, there is no need in Attunity anymore.
Microsoft Oracle Connector supersedes it.
Thank you.
I've gone through the thread, but how did you make it work at last ?
Thank you so much for your answer.
Just look at my answer there. Everything else is a white noise.
Thank you .
Yes, it solved the problem by using EzConnect format: [//]host[:port][/service_name].
But the other option : The connect descriptor name defined in the tnsnames.ora file that located in the admin folder of the Oracle client.
according to: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connection-manager?view=sql-server-ver15:
should also solve the problem but it does not seem to do, at least in my case.
Thank you again.
Good to hear that you solved the issue.
Please connect with me on LinkedIn.