Share via

Provision SSIS runtime in Azure

  • Code Sample
Browse code

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check

Deploy To Azure Deploy To Azure US Gov Visualize

This template creates a data factory of version 2, and then configures an Azure SSIS integration runtime in the cloud. Then, you can use SQL Server Data Tools or SQL Server Management Studio to deploy SQL Server Integration Services (SSIS) packages to this runtime on Azure.

The prerequisites for this template are mentioned in the Tutorial: Provision Azure SSIS integration runtime article.

When you deploy this Azure Resource Manager template, a data factory of version 2 is created with an Azure SSIS integration runtime. It also creates the SSIS Catalog (SSISDB) database in the Azure SQL database you specify as an argument.

Next steps

  1. Click the Deployment succeeded message.
  2. Click Go to resource group.
  3. Search for *datafactory that's created.
  4. See Provision Azure SSIS integration runtime section to navigate to the Integration Runtimes page.
  5. Start/stop the integration runtime as needed.

Tags: Microsoft.DataFactory/factories, Microsoft.DataFactory/factories/integrationRuntimes, Managed, SecureString, Microsoft.Network/virtualNetworks, Microsoft.Sql/servers, firewallrules, databases