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 platform for building enterprise-level data integration and data transformation solutions. SSIS is used to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.
One of the frequently asked questions is do we need to install SQL Server Data Tools (SSDT) on the SQL Server and the answer is YES.
SSDT is used within Visual Studio for developing Integration Services packages and it is required to be installed in the development environment in order to create Integration Services projects. Although it is optional for a SQL Server installation, it is mandatory for COZYROC SSIS+ Suite and can co-exist with SSIS on the same server.
To verify if SSIS is installed on the SQL Server, you can use a tool called SQL Server Configuration Manager (SSCM). SSCM is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.
Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows.
Follow these steps to open SQL Server Configuration Manager:
- To open the SQL Server Configuration Manager, go to the Start Page or Search box (see Figure 01).
- Type the SQLServerManager<version>.msc such as SQLServerManager14.msc for SQL Server 2017, and then press the Enter Key.
- When the SQL Server Configuration Manager appears, Click on the SQL Server Services in the left panel (see Figure 02).
Note: if SQL Server Integration Services is installed and running, it will appear in the right panel (see Figure 03).