Reconfigure the Azure-SSIS integration runtime

APPLIES TO: yesAzure Data Factory noAzure Synapse Analytics (Preview)

This article describes how to reconfigure an existing Azure-SSIS integration runtime. To create an Azure-SSIS integration runtime (IR) in Azure Data Factory, see Create an Azure-SSIS integration runtime.

Data Factory UI

You can use Data Factory UI to stop, edit/reconfigure, or delete an Azure-SSIS IR.

  1. Open Data Factory UI by selecting the Author & Monitor tile on the home page of your data factory.
  2. Select the Manage hub below Home, Edit, and Monitor hubs to show the Connections pane.

To reconfigure an Azure-SSIS IR

On the Connections pane of Manage hub, switch to the Integration runtimes page and select Refresh.

Connections pane

You can edit/reconfigure your Azure-SSIS IR by selecting its name. You can also select the relevant buttons to monitor/start/stop/delete your Azure-SSIS IR, auto-generate an ADF pipeline with Execute SSIS Package activity to run on your Azure-SSIS IR, and view the JSON code/payload of your Azure-SSIS IR. Editing/deleting your Azure-SSIS IR can only be done when it's stopped.

Azure PowerShell

Note

This article has been updated to use the new Azure PowerShell Az module. You can still use the AzureRM module, which will continue to receive bug fixes until at least December 2020. To learn more about the new Az module and AzureRM compatibility, see Introducing the new Azure PowerShell Az module. For Az module installation instructions, see Install Azure PowerShell.

After you provision and start an instance of Azure-SSIS integration runtime, you can reconfigure it by running a sequence of Stop - Set - Start PowerShell cmdlets consecutively. For example, the following PowerShell script changes the number of nodes allocated for the Azure-SSIS integration runtime instance to five.

Reconfigure an Azure-SSIS IR

  1. First, stop the Azure-SSIS integration runtime by using the Stop-AzDataFactoryV2IntegrationRuntime cmdlet. This command releases all of its nodes and stops billing.

    Stop-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName 
    
  2. Next, reconfigure the Azure-SSIS IR by using the Set-AzDataFactoryV2IntegrationRuntime cmdlet. The following sample command scales out an Azure-SSIS integration runtime to five nodes.

    Set-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -NodeCount 5
    
  3. Then, start the Azure-SSIS integration runtime by using the Start-AzDataFactoryV2IntegrationRuntime cmdlet. This command allocates all of its nodes for running SSIS packages.

    Start-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName
    

Delete an Azure-SSIS IR

  1. First, list all existing Azure SSIS IRs under your data factory.

    Get-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -ResourceGroupName $ResourceGroupName -Status
    
  2. Next, stop all existing Azure SSIS IRs in your data factory.

    Stop-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
    
  3. Next, remove all existing Azure SSIS IRs in your data factory one by one.

    Remove-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
    
  4. Finally, remove your data factory.

    Remove-AzDataFactoryV2 -Name $DataFactoryName -ResourceGroupName $ResourceGroupName -Force
    
  5. If you had created a new resource group, remove the resource group.

    Remove-AzResourceGroup -Name $ResourceGroupName -Force 
    

Next steps

For more information about Azure-SSIS runtime, see the following topics:

  • Azure-SSIS Integration Runtime. This article provides conceptual information about integration runtimes in general including the Azure-SSIS IR.
  • Tutorial: deploy SSIS packages to Azure. This article provides step-by-step instructions to create an Azure-SSIS IR and uses Azure SQL Database to host the SSIS catalog.
  • How to: Create an Azure-SSIS integration runtime. This article expands on the tutorial and provides instructions on using Azure SQL Managed Instance and joining the IR to a virtual network.
  • Join an Azure-SSIS IR to a virtual network. This article provides conceptual information about joining an Azure-SSIS IR to an Azure virtual network. It also provides steps to use Azure portal to configure virtual network so that Azure-SSIS IR can join the virtual network.
  • Monitor an Azure-SSIS IR. This article shows you how to retrieve information about an Azure-SSIS IR and descriptions of statuses in the returned information.