Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

if you face an issue when the Attunity connectors aren't visible in the SSIS Toolbox...

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
First published on MSDN on May 22, 2017 To see the Attunity connectors in the SSIS Toolbox, you always have to install the version of the connectors that targets the same v...
Published Mar 25, 2019
Version 1.0
jahill's avatar
jahill
Copper Contributor
Mar 21, 2022

I'm trying to figure out if and what Affinity connector to use. We had previously not been able to get it work on SQL Server 14 on Windows Server 2012 R2. We have upgraded to SQL Server 14 We are just upgrading our SQL Server. Currently our plan is to upgrade to SQL Server 2016. So our system will be

  • Windows Server 2012 R2
  • SQL Server 2016
  • Visual Studio 2017 with SSIS Version 14.0.3002.68
  • Oracle 19c.

The requirements for Microsoft Connectors v4.0 for Oracle say  Supported Oracle databases : Oracle 10.x; Oracle 11.x; Oracle 12c. Not sure if that just means it's not supported by Microsoft or that it will not work period with Oracle 19c. The OLE DB Source/destination are so much slower than the oracle ones and we would like to take advantage of the oracle destination/source ones.

 

Can this be done or do we have to wait and upgrade to SQL Server 2019?