How to check the version installed for SQL Server, Visual Studio, SSDT/SSIS Projects, and COZYROC SSIS+
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.
From the Windows Start Menu, locate the COZYROC SSIS+ program and then Click to expand the sub-menu.
- Right-Click on the highest release available of the License Application and run as administrator (See Figure-01).
Note: when the COZYROC License window appears, you find the release number (See Figure-02).
Verifying the SQL Server Data Tools (SSDT) or SQL Server Integration Services Projects (SSIS Projects) 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.
- From the Windows Start Menu, locate the Windows System folder and then Click to expand the sub-menu.
- Click on the Control Panel (See Figure-04).
- Click on Program and then Click on Programs and Features.
- When the Program and Features Window appears, scroll down and locate the program Microsoft SQL Data Tools - Visual Studio 2017 (See Figure-05).
- 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).
After Visual Studio 2017 you need to install the SQL Server Integration Services Projects Addon. To check what version you have installed, you could use Control Panel>> Programs>> Programs and Features (see the example below):
or in Visual Studio go to Manage Extensions and check the version:
Verifying the Visual Studio Release
- From the Windows Start Menu, locate the Visual Studio program.
- Right-Click on Visual Studio and run as administrator (See Figure-07).
- Click on Help from the Menu bar.
- 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).
Verifying the SQL Server Version
Within a new Query window in SSMS, execute the SQL select statement 'SELECT @@version'.
To check whether the core Integration Services (SSIS) is installed on your server, please refer to our guide on How To verify Microsoft Integration Services is installed on SQL Server .
Book a Success Call
Need Help?
Evaluating COZYROC? --> Success Call
Customers --> Submit a Ticket
Related Articles
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 (please see the ...Understanding SSIS Architecture: Where to Install SSIS and COZYROC SSIS+
Understanding SSIS Architecture: Storage, Scheduling, and Execution The Three Critical Locations You Need to Understand When working with SSIS packages, there are three distinct concepts that customers often confuse. Understanding where each ...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 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 ...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 ...