Why are there not any modules during the installation?
Issue:
While installing COZYROC SSIS+ Suite I don't see any modules listed. Please look at the screenshot below:
Solution:
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 | Registry key |
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
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
Why am I missing SQL Server modules when installing COZYROC SSIS Plus?
During the installation, you would likely see all of the other versions of SQL Server modules that the version of COZYROC SSIS+ being installed is compatible with. If you are only seeing just the highest SQL Server module during the install, then it ...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 ...Cannot create a task from XML for task, type SSIS.ReplacementTask due to error The parameter is incorrect.
Action: After upgrading from SQL 2016 to SQL 2019 and upgrading SSIS+ from 1.8 to 2.0 I opened the package in VS2019 and received the following error message. Error Message: ''Cannot create a task from XML for task, type SSIS.ReplacementTask due to ...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 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 ...