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.- 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 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 .
- 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) .
NOTE: For VS2019, please look for the version of "SQL Server Integration Services Project" extension instead.
- 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 ).
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'.
Book a Presales Call
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 ...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 ...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 ...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 ...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 ...