Azure-SSIS Integration Runtime is now generally available in Azure Synapse Analytics, allowing you to use it and the Execute SSIS Package activity in your Synapse pipelines. This article provides a comprehensive guide on how to create an Azure-SSIS integration runtime (IR) in Azure Data Factory (ADF) or Synapse Analytics via the Azure portal.

The Azure-SSIS IR supports running packages deployed into the SSIS catalog (SSISDB) hosted by Azure SQL Database server or Managed Instance (Project Deployment Model), as well as packages deployed into Azure Files (Package Deployment Model).

To provision an Azure-SSIS IR, you can do so in the ADF or Synapse Analytics portals. The process involves configuring general, deployment, and advanced settings for your IR.

In the general settings, you’ll specify the name, description, location, node size and number, SQL Server edition, and Azure Hybrid Benefit for your IR.

In the deployment settings, you can choose to create an SSISDB instance hosted by an Azure SQL Database server or Managed Instance to store your projects, packages, environments, and execution logs. Alternatively, you can deploy your packages to the file system, Azure Files, or MSDB hosted by Azure SQL Managed Instance. You also have the option to create Azure-SSIS IR package stores to manage your deployed packages.

The advanced settings allow you to configure the maximum number of parallel package executions per node, customize your IR with additional system configurations or component installations, join your IR to a virtual network, and set up a self-hosted IR as a proxy.

Once provisioned, you can view and manage your Azure-SSIS IR using the Connections pane in the ADF or Synapse Analytics portals. Here, you can edit, reconfigure, monitor, start, stop, and delete your IR, as well as auto-generate ADF pipelines with the Execute SSIS Package activity to run on your IR.

This comprehensive guide covers all the steps and options available when creating an Azure-SSIS IR, equipping you with the knowledge to provision and manage this powerful integration runtime for your data integration needs in Azure.