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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
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 ...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 do I start using COZYROC SSIS+ in Business Intelligence Development Studio (BIDS) or Visual Studio?
As of the 2012 version of Visual Studio, there is no need to import the extensions for SSIS+. When you run the COZYROC installer package file, the extensions are imported and the COZYROC SSIS+ components and tasks will show up in the SSIS Toolbox. If ...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 ...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 ...