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 |
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.