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.


    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.

      • Related Articles

      • COZYROC recommended SSDT versions for Data Flow Task Plus

        SQL Server Target COZYROC SSIS+ Versions SSDT Version Recommended SQL Server 2022 2.2.1.3550+ (2.2.1.3550 and above) 2.1.100.3064+ (2.1.100.3064 and above) SSDT for VS2022 1.3.2 SSDT for VS2019 4.4 SQL Server 2019 1.9+ (1.9 or higher) 3.16 for VS2019 ...

      • 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 SSDT ...

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

      • Dynamic Data Flow - Dynamic Column Custom Handler

        To setup custom routine in the data flow script for additional setup of dynamically added data flow column, attribute your script main class with DataFlowColumnAdded attribute. Set as parameter the name of the script method. Check below the required ...

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