License

Overview

The SSIS+ 1.3 library contains license verification code. When running SSIS project containing CozyRoc SSIS+ components under Business Intelligence Development Studio (BIDS), the license verification code is not active. You can test and develop with the SSIS+ components for as long as needed to determine if the components are suitable for your needs. When you run the SSIS package from the command line with DTEXEC or SQL Server Agent, the license verification code is activated. If license is not found, the package execution will fail, the first time it tries to use SSIS+ library component.

How to license my SSIS+ installation?

Note:

The instructions below are for SSIS+ 1.3 SR-4 and newer. The license key deployment process has been simplified. Make sure you download and install the latest version.

The SSIS+ library has to be licensed on every production server. The library installation contains license key deployment application. The application is located in the Start menu:

Start -> All Programs -> CozyRoc SSIS+ -> License

IMPORTANT: You have to run the application on your target production server, where the SSIS+ library will be installed.

Make sure you execute License application in administrative mode (Run As ...). When you run the License application, it will show your machine identifier and two different options for requesting license key:

• Licensee - depending on what type of purchase you have made, you have to provide:
  • Subscription Number - if you have purchased SSIS+ Ultimate Subscription.
  • Receipt Number - if you have purchased SSIS+ perpetual license.
  • Custom licensee identifier - provided by the CozyRoc staff.
• Email and Payment - use the email you have used to make the purchase and the amount you have paid.

After you enter the licensee, press the button on the right to request your license key. If the license key is deployed successfully the application will change accordingly, showing the licensed version and expiration date (if the license is time-limited). If there are issues, the application will show errors on the bottom.

License key deployment of SSIS+ Ultimate Subscription

The SSIS+ Ultimate Subscription have time-limited license keys. After the expiration period has passed, the library will try to automatically contact the CozyRoc license server and retrieve license key for the next subscription period. To ensure uninterrupted service, you have to:

• Permit your SSIS server and SQL Job Agent to communicate on port 80 with the CozyRoc license server at: http://www.cozyroc.com
• Execute SSIS package under SQL Job Agent and test the communication with the license server. To test the communication, follow these steps:
  • Open your registry and go to the following registry key:
    

    32bit - HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS
    64bit - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS

    If you are running SQL 2008, go to the following registry key:

    32bit - HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc.2008\SSIS
    64bit - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc.2008\SSIS

  • There is a DWORD value called ContactLicenseServer. Set this special flag temporary to 1, to always contact the CozyRoc license server when executing SSIS packages.
  • Run one of your production SSIS packages under SQL Job Agent manually. After it finishes executing, inspect your SQL Job Agent execution log. If you don't see errors or warnings, then everything is fine and your deployment is complete.
  • Go to the registry and reset ContactLicenseServer value to 0.

Can I request production machine testing license?

Yes. To request trial license key enter "TRIAL" in the Licensee input box in the License application.

How many licenses have to be purchased for a SQL Server running in a cluster configuration?

It depends. For a 2 node cluster, running in Active/Active configuration you have to purchase 2 production licenses. If your cluster node is Active/Passive configuration, you have to purchase 1 license.

When executing SSIS package from the command line, it works properly. However when I run the same package from the SQL Job Agent it fails.

Make sure your SQL Job Agent user account has permissions to:

• CozyRoc SSIS+ installation folder (READ and WRITE).
• Windows temp folder (READ and WRITE). The default location is here: C:\Windows\TEMP
• For SQL 2005, registry keys (READ only):
  

  32bit - HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc\SSIS
  64bit - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc\SSIS
  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\ProductID

• For SQL 2008, registry keys (READ only):
  

  32bit - HKEY_LOCAL_MACHINE\SOFTWARE\CozyRoc.2008\SSIS
  64bit - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CozyRoc.2008\SSIS
  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup

My server sits behind firewall and I'm unable to contact the CozyRoc license server. What I should do next?

Use the license request page to get your license key. After you download the license key file, deploy it using the License application (1.4). If you are SSIS+ 1.3 user, you have to manually deploy in the SSIS+ installation folder.

• For 32bit the default installation folder:

\\Program Files\CozyRoc\SSIS

• For 64bit the default installation folder:

\\Program Files (x86)\CozyRoc\SSIS