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 version of SQL Server as the version of SQL Server Data Tools (SSDT) installed on your computer. (You may also have earlier versions of the connectors installed.) This requirement is independent of the version of SQL Server that you want to target in your SSIS projects and packages. +


For example, if you've installed the latest version of SSDT, you have version 17 of SSDT with a build number that starts with 14. This version of SSDT adds support for SQL Server 2017. To see and use the Attunity connectors in SSIS package development - even if you want to target an earlier version of SQL Server - you also have to install the latest version of the Attunity connectors, version 5.0. This version of the connectors also adds support for SQL Server 2017. +


Check the installed version of SSDT in Visual Studio from Help | About Microsoft Visual Studio , or in Programs and Features in the Control Panel. Then install the corresponding version of the Attunity connectors from the following table. +



SSDT versionSSDT build numberTarget SQL Server versionRequired version of Connectors
17 Starts with 14 SQL Server 2017 https://www.microsoft.com/download/details.aspx?id=55179
16 Starts with 13 SQL Server 2016 https://www.microsoft.com/download/details.aspx?id=52950
Published Mar 25, 2019
Version 1.0

2 Comments

  • 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?

  • Gammelfarfar's avatar
    Gammelfarfar
    Copper Contributor
    Oct 20, 2021

    Nope, did this. Didn't work. Still no Attunity connector.
    Drivers are all installed. No error messages. Installed and uninstalled VS and SSDT.

    As a last ditch effort I even tried using gacutil to manually add the missing dll in the global assembly cache but the dll doesn't have a manifest.