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. +
|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|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.