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.
COZYROC recommended SSDT versions for Data Flow Task Plus
SQL Server Target COZYROC SSIS+ Versions SSDT Version Recommended SQL Server 2022 220.127.116.1150+ (18.104.22.16850 and above) 22.214.171.12464+ (126.96.36.19964 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 ...
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 ...
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 ...