Database Integration Service Server Role and Associations
The Database Integration Service Server is a dedicated SQL Server that runs the integration services (SSIS), such as Extraction, Transform, and Load (ETL). This configuration is an option that provides a separation of duties in deployments with remote SQL Servers (SQL Farms/Clusters).
Configure the Database Integration Service server role Entity that contains a logical, predefined set of components (system software or certified third-party software) deployed in the Data Center and Site Zones that provide specific functionality for the system. on the DBMS. Once configured, the SSIS run only on the Database Integration Service Server instead on the remote SQL Servers.