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. NOTE: Put the identified in quotes in case it contains spaces.
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 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 Success Call
Need Help?
Evaluating COZYROC? --> Success Call
Customers --> Submit a Ticket
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: ...How to do Event-Based processing in SSIS with COZYROC
Choosing the Right COZYROC Event‑Driven SSIS Option: Cloud Webhooks, Hybrid Runtimes, or SSIS NoW COZYROC offers three closely related options for event‑driven SSIS: COZYROC Cloud with managed runtime and inbound webhooks, COZYROC Cloud with ...How to check the version installed for SQL Server, Visual Studio, SSDT/SSIS Projects, and COZYROC SSIS+
Verifying the COZYROC SSIS+ Release The existing release of the COZYROC SSIS+ Suite can easily be identified through the License Application, which is installed during setup. The License Application is used to retrieve and/or remove the license key. ...Understanding SSIS Architecture: Where to Install SSIS and COZYROC SSIS+
Understanding SSIS Architecture: Storage, Scheduling, and Execution The Three Critical Locations You Need to Understand When working with SSIS packages, there are three distinct concepts that customers often confuse. Understanding where each ...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 ...