Why are there not any modules during the installation?
While installing COZYROC SSIS+ Suite I don't see any modules listed. Please look at the screenshot below:
The issue is that the required registry settings are missing and our installation is not able to find where SSIS is installed on the machine. There is a bug in the SQL Server installation where if the installation is made on a drive different from the default, the required registry settings are not configured properly. If SSIS is installed on a drive different from the default C: drive then you see that issue.
To solve the issue you need to manually create the registry keys pointing to your SQL Server installation location. You can find the correct registry key for your SQL Server version in the table below:
SQL Server version
SQL Server 2012
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\110\SSIS\Setup\DTSPath
SQL Server 2014
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\120\SSIS\Setup\DTSPath
SQL Server 2016
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\130\SSIS\Setup\DTSPath
SQL Server 2017
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\140\SSIS\Setup\DTSPath
SQL Server 2019
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\150\SSIS\Setup\DTSPath
You should follow the steps below:
1) Manually create the correct registry key and enter the path as the default value. For example I am using SQL Server 2017 and my registry key will look the following way:
2) Install COZYROC SSIS+ Suite and keep all installation defaults, you should be able to see now the missing modules
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 ...
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 ...
What are the recommended steps for installation?
Review the information on the Installation and Getting Started page; the Compatibility Chart is especially important. This will ensure proper installation and configuration of your environment and ensure that the COZYROC SSIS+ Suite will work with ...
After installation, I cannot find the COZYROC License Application.
With the release of the Windows Vista operating system, and included in all Windows operating systems released after that, a new security feature was introduced called User Account Control (UAC). It is enabled, by default, on those systems and is ...