if you face an issue when the Attunity connectors aren’t visible in the SSIS Toolbox…

This post has been republished via RSS; it originally appeared at: SQL Server Integration Services (SSIS) articles.

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 Microsoft Connectors v5.0 for Oracle and Teradata
16 Starts with 13 SQL Server 2016 Microsoft Connectors v4.0 for Oracle and Teradata

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.