SQL Server registry keys used by the COZYROC SSIS+ Library
Note
:
If the appropriate SQL Server Key listed below is not present on the machine, then it is likely that the correct SQL Server Integration Services (SSIS) is not installed on the machine. This may result in the error message "
Unable to retrieve digital product id
" when you open the SSIS+ License application to deploy your license keys. In addition, the COZYROC SSIS+ components will not show up in the SSIS Toolbox.
Version
|
Registry keys (READ only)
|
2005
|
32
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\ProductID
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\ProductID
|
2008
|
32
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\DTS\Setup
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\100\DTS\Setup
|
2012
|
32
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\DTS\Setup
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\110\DTS\Setup
|
2014
|
32
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\DTS\Setup
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\120\DTS\Setup
|
2016
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\130\DTS\Setup
|
2017
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\140\DTS\Setup
|
2019
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\150\DTS\Setup
|
2022
|
64
|
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\160\DTS\Setup
|
Book a Presales Call
Related Articles
Error Message: Unable to retrieve digital product id
Action: When opening the SSIS+ License Application, you receive the following error. Error Message: ‘Unable to retrieve digital product id’ Solution: Make sure the SQL Server registry key for SSIS is present for the version of SQL Server you are ...
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 ...
How to retrieve the license key via the License Application
As part of the COZYROC SSIS+ Suite installation, the License Application is installed and it is located under the Submenu of COZYROC SSIS+. To retrieve the License Key from the COZYROC server, follow these steps: IMPORTANT: The License Application ...
How-To add a component to the SSIS Toolbox for SQL Server 2005 and 2008?
As of SQL Server 2012 , the SSIS Toolbox does not have the Choose Toolbox Items option. Custom components are now automatically detected and added to the SSIS Toolbox. The SSIS Toolbox Component can be easily customized. Items can be added, ...
Error message: Null method parameter #4
Action: When opening the SSIS+ License Application, you receive the following error. Error Message: Null method parameter #4 Solution: Make sure the SQL Server registry key for SSIS is present for the version of SQL Server you are using. If it is not ...