#Ssdt for visual studio 2017 software#

In summary, our software should work for the following Windows operating systems. The general guideline is the newer the operating system is, the better. We don't have any additional requirements for the operating system as long as it satisfies the minimum requirements of SSIS runtime or design-time. Windows operating system requirement largely depends on the version of SSIS runtime or design-time selected. The Business Intelligence Development Studio that is shipped with the installation media of the corresponding SQL Server version.

Packages created using SSDT 2015 need to have their project's TargetServerVersion setting set to ' SQL Server 2012' in order to work with SSIS 2012.

Packages created using SSDT 2017 need to have their project's TargetServerVersion setting set to ' SQL Server 2012' in order to work with SSIS 2012.

SSDT for Visual Studio 2017 (not recommended due to potential compatibility issues with ISV solutions).

Packages created using SSDT 2019 need to have their project's TargetServerVersion setting set to ' SQL Server 2012' in order to work with SSIS 2012.

SSDT for Visual Studio 2019 (not recommended due to potential compatibility issues with ISV solutions).

SSDT-BI for Visual Studio 2012 (recommended most reliable).

Packages created using SSDT 2015 need to have their project's TargetServerVersion setting set to ' SQL Server 2014' in order to work with SSIS 2014.

Packages created using SSDT 2017 need to have their project's TargetServerVersion setting set to ' SQL Server 2014' in order to work with SSIS 2014.

Packages created using SSDT 2019 need to have their project's TargetServerVersion setting set to ' SQL Server 2014' in order to work with SSIS 2014.

#Ssdt for visual studio 2017 install#

Note: When using SQL Server 2014, a cumulative update is required (a recent service pack, such as one of the following, is preferred) to run our software during runtime.įor SSIS design-time, you should install the version of SSDT (SQL Server Data Tools) or BIDS (Business Intelligence Development Studio) that aligns with the SQL Server version that you plan to use for your final deployment (the runtime).