How To verify Microsoft Integration Services is installed on SQL Server

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:
  1. To open the SQL Server Configuration Manager, go to the Start Page or Search box (see Figure 01).
  2. Type the SQLServerManager<version>.msc such as SQLServerManager14.msc for SQL Server 2017, and then press the Enter Key.
  3. 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).


Figure 01


Figure 02


Figure 03

    • Related Articles

    • Error Message: Found no compatible SSIS framework. Installation aborted

      Action: When trying to install the COZYROC SSIS+, I received the following error message: Error Message: “Found no compatible SSIS framework. Installation aborted”. Solution: This error message indicates that you do not have properly installed SQL ...
    • How To Check the Version Installed for Visual Studio, SSDT, and COZYROC SSIS+

      Once you have verified which versions you have installed below, please jump over to our Compatibility Charts on the Installation and Getting Started page to make sure all of these component are compatible with each other. Demonstration Video ...
    • 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 ...
    • 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 ...
    • How to upgrade an existing COZYROC SSIS+ Suite installation to a higher version.

      Before upgrading your existing COZYROC SSIS+ Suite to a higher version, we recommend that you first review this entire page in detail.  Depending on your upgrade situation you may need to reference the Compatibility Charts on the Installation and ...