Overview
You can use the SSIS+ components in your development environment (Visual Studio with SSDT or BIDS) as long as you need to, without worrying about licensing. However when you run a SSIS package from the command line with DTEXEC or the SQL Job Agent, a check for a valid SSIS+ license would be performed. The package execution will fail if there is no valid license activated.
Registry keys used by the COZYROC SSIS+ library
| Version | Registry keys (READ only) | |
|---|---|---|
| 2005 | 32 | HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS |
| 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS | |
| 2008 | 32 | HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS.2008 |
| 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS.2008 | |
| 2012 | 32 | HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS.2012 |
| 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS.2012 | |
| 2014 | 32 | HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS.2014 |
| 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS.2014 | |
| 2016 | 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS.2016 |
| 2017 | 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS.2017 |
| 2019 | 64 | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS.2019 |
SQL Server registry keys used by the COZYROC SSIS+ library
| 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 |
Demonstration
Knowledge Base
- Can I test packages using SSIS+ components without buying a license?
- Licensing
- Error Message: License file C:\Program Files (x86)\CozyRoc\SSIS\License.dat is busy.
- Error Message: Server returned a fault exception: [0] License not found for specified identifier?
- Error Message: The request was aborted: The operation has timed out.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.