Is it required to install SSDT on the SQL Server?

Is it required to install SSDT on the SQL Server?

SQL Server Development Tools (SSDT) will always need to be installed on the machine(s) where you design your packages. It allows you to design and deploy SSIS packages using Visual Studio.

For SSIS+ releases prior to 2.0:

If you are using Data Flow Task Plus in your packages, you will need to install SQL Server Development Tools (SSDT) on the SQL Server where your packages are scheduled and executed. If you are not using Data Flow Task Plus, you will only need to install SQL Server Integration Services (SSIS) and the COZYROC SSIS+ Suite on the server where you schedule and execute packages; SSDT will not be needed.

For SSIS+ release 2.0 and later:

You will not need to install SSDT on the SQL Server where your packages are scheduled and executed, even if you are using Data Flow Task Plus. You will only need to install SQL Server Integration Services (SSIS) and the COZYROC SSIS+ Suite on the server where you schedule and execute packages.


    • Related Articles

    • COZYROC recommended SSDT versions for Data Flow Task Plus

      SQL Server Target COZYROC SSIS+ Versions SSDT Version Recommended SQL Server 2019 1.9+   (1.9 or higher) 3.10 for VS2019 15.9.1 for VS2017 SQL Server 2017 1.8+   (1.8 or higher) 15.8.0 for VS2017 17.4.0 for VS2015 SQL Server 2016 1.7+ (1.7 or higher) ...
    • Installation and Getting Started

      Overview This article contains information to help ensure proper installation and configuration of your environment, but most importantly, ensure that COZYROC SSIS+ Suite will work with the installed components (e.g., SQL Server, SSDT).  Although ...
    • How To verify Microsoft Integration Services is installed on SQL Server

      SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server.  The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...
    • How to build the data flow setup

      The initialization and user interface for a data flow is defined by implementing properties on the script EntryPoint class. The documentation and samples of Script Task Plus for defining parameters is relevant to the Data Flow Task Plus ...
    • What are the recommended steps for installation?

      Review the information on the Installation and Getting Started page; the Compatibility Chart is especially important.  This will ensure proper installation and configuration of your environment and ensure that the COZYROC SSIS+ Suite will work with ...