How To Check the Version Installed for Visual Studio, SSDT, and COZYROC SSIS+

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


Verifying the COZYROC SSIS+ Release


The existing release of the COZYROC SSIS+ Suite can easily be identified through the License Application, which is installed during setup. The License Application is used to retrieve and/or remove the license key.

NOTE: For newer SSIS+ releases it's also displayed in all task/component editor forms.

  1. From the Windows Start Menu , locate the COZYROC SSIS+ program and then Click to expand the sub-menu.
  2. Right-Click on the highest release available of the License Application and run as administrator ( See Figure-01 ).
Figure 01 Figure 01
Figure 02 Figure 02


Note: when the COZYROC License window appears, you find the release toward the bottom left corner ( See Figure-02 ).

Verifying the SQL Server Data Tools (SSDT) Release


One method in how to verify your current SSDT release is through the Control Panel ➡ Programs ➡ Programs and Features . Programs that are installed on your server are tracked and/or listed under the Programs and Features , which can be accessed through Control Panel .
  1. From the Windows Start Menu , locate the Windows System folder and then Click to expand the sub-menu.
  2. Click on the Control Panel ( See Figure-04 ).
  3. Click on Program and then Click on Programs and Features .
  4. When the Program and Features Window appears, scroll down and locate the program Microsoft SQL Data Tools - Visual Studio 2017 (See Figure-05) .  
    NOTE: For VS2019, please look for the version of "SQL Server Integration Services Project" extension instead.

  5. Using the  Compatibility Chart for SSDT , look up the build number to identify the release of SSDT.

Note: although Visual Studio provides version information, the information associated with SSDT can't help identify the accurate build number and/or release installed (See Figure-06 ).
Figure 04 Figure 04
Figure 05 Figure 05

Figure 06 Figure 06

Verifying the Visual Studio Release

  1. From the Windows Start Menu , locate the Visual Studio program.
  2. Right-Click on Visual Studio and run as administrator ( See Figure-07 ).
  3. Click on Help from the Menu bar.
  4. When the sub-menu appears, Click on the About Microsoft Visual Studio ( See Figure-08 ).

Note: when the About Microsoft Visual Studio dialog window appears, you will find the version located underneath the program name (e.g., Microsoft Visual Studio Community 2017).

Figure 07 Figure 07

Figure 08 Figure 08

Figure 09 Figure 09

Verifying the SQL Server Version

  1. Within a new Query window in SSMS, execute the SQL select statement 'SELECT @@version'.

    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

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

      • 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 download and install the COZYROC SSIS+ Components Suite

        Your computer must have the following minimum requirements in order to use the COZYROC SSIS+ Components Suite : Operating Systems Windows Server 2022 Windows 11 Windows Server 2019 Windows 10 version 1507 or higher: Home, Professional, Education, and ...

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

      • Why do I not see the COZYROC components in the SSIS Toolbox in Visual Studio?

        If you do not see the COZYROC SSIS+ components showing up in the SSIS Toolbox in Visual Studio then one of the following may be the reason they are not showing. 1. There is an incompatibility in your installation.  You will want to insure by looking ...