How to setup a new SSIS IR with SSIS+ via the Azure web UI
The creation of a new SSIS IR via the Azure web UI is quite straightforward. Please follow the instructions from Provision the Azure-SSIS integration runtime - Azure Data Factory | Microsoft Docs and Customize the setup for an Azure-SSIS Integration Runtime - Azure Data Factory | Microsoft Docs . You will need to create a blob container and upload to it the desired version of SSIS+ (we usually recommend the latest official SSIS+ release) and to have a main.cmd with content like this:
msiexec /i SSISPlus-x64.msi /quiet /l %CUSTOM_SETUP_SCRIPT_LOG_DIR%install.log
"C:\Program Files (x86)\CozyRoc\SSIS\License.exe" /azure /v /u TRIAL /d /l "%CUSTOM_SETUP_SCRIPT_LOG_DIR%license.log"
In the line above, please replace TRIAL with your Licensee Identifier, if you have already purchased a COZYROC SSIS+ license. Also make sure that you have renamed the build that you would like to use to SSISPlus-x64.msi in order to match the name in the script.
Also, please check: How to cache an SSIS+ license in Azure SSIS IR to prevent downtime issues with COZYROC License ServerThe custom setup Azure Blob container expects a Read/List/Write access, provided via a SAS URI like this:
After completing the setup and starting the SSIS IR, a log directory should be created in the blob container.
NOTE: If you are have used the modified version of the script for caching License.dat file, you can copy it from the log directory to the root of the container.
NOTE: If you are have used the modified version of the script for caching License.dat file, you can copy it from the log directory to the root of the container.
NOTE: COZYROC is not responsible for maintaining and supporting a customer's environment. The intention of this KB article is to give the customer a step in the right direction for installation in Azure. Further assistance may involve contacting Microsoft Azure support.
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
How to cache an SSIS+ license in Azure SSIS IR to prevent downtime issues with COZYROC License Server
Action: When trying to run packages in Azure SSIS IR VM, the following licensing error message is received: Error Message: “License: 'License.dat' file not found.” In the latest log folder of the BLOB storage, there are the following lines: ...Where can I find the documentation for the Azure Table Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Azure Table Connection can be found at the following link. For many of the components you can find ...How To Check the Version Installed for Visual Studio, SSDT, and COZYROC SSIS+
Once you have verified which versions you have installed below, please jump over to our Compatibility Charts on the Installation and Getting Started page to make sure all of these component are compatible with each other. Demonstration Video ...What are the recommended steps for installation?
Review the information on the Installation and Getting Started page; the Compatibility Chart is especially important. This will ensure proper installation and configuration of your environment and ensure that the COZYROC SSIS+ Suite will work with ...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 ...