Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

General availability of Microsoft Connector for Oracle

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
May 25, 2020
Microsoft Connector for Oracle is now generally available.    Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages desig...
Updated May 25, 2020
Version 1.0
kenny_tkc's avatar
kenny_tkc
Copper Contributor
Oct 05, 2020

I extract data from 200+ tables from an Oracle database into SQL server and I am running into connection errors while the packages are running.  This was not experienced with using Attunity 5.0.  The are 6 packages running in parallel pulling data.

  • Found that moving from a project connection to a package connection helped considerably although connection issues were still occuring.
  • Found that restricting the number of active package running in parallel (and therefore data flows) reduced the number of issues (48 core server).  However, reducing the number of parallel tasks extended the runtime out of the acceptable time range.
  • Most of the dataflows in the same failed package will complete without error. 
  • The data flow that fails seems to random.

This is the error returned from the data flow on failure.  

Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Connection OracleSource" failed with error code 0xC0014009.