Reconfigure the Azure-SSIS integration runtime
APPLIES TO: Azure Data Factory Azure Synapse Analytics (Preview)
This article describes how to reconfigure an existing Azure-SSIS integration runtime. To create an Azure-SSIS integration runtime (IR), see Create an Azure-SSIS integration runtime.
You can use Data Factory UI to stop, edit/reconfigure, or delete an Azure-SSIS IR.
- Open Data Factory UI by selecting the Author & Monitor tile on the home page of your data factory.
- Select the Manage hub below Home, Edit, and Monitor hubs to show the Connections pane.
To reconfigure an Azure-SSIS IR
On Manage hub, switch to the Integration runtimes page and select Refresh.
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.
We recommend that you use the Azure Az PowerShell module to interact with Azure. See Install Azure PowerShell to get started. To learn how to migrate to the Az PowerShell module, see Migrate Azure PowerShell from AzureRM to Az.
After you provision and start an instance of Azure-SSIS integration runtime, you can reconfigure it by running a sequence of
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.
For Azure-SSIS IR in Azure Synapse Analytics, replace with corresponding Azure Synapse Analytics PowerShell interfaces: Get-AzSynapseIntegrationRuntime, Set-AzSynapseIntegrationRuntime (Az.Synapse), Remove-AzSynapseIntegrationRuntime, Start-AzSynapseIntegrationRuntime and Stop-AzSynapseIntegrationRuntime.
Reconfigure an Azure-SSIS IR
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
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
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
First, list all existing Azure SSIS IRs under your data factory.
Get-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -ResourceGroupName $ResourceGroupName -Status
Next, stop all existing Azure SSIS IRs in your data factory.
Stop-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
Next, remove all existing Azure SSIS IRs in your data factory one by one.
Remove-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
Finally, remove your data factory.
Remove-AzDataFactoryV2 -Name $DataFactoryName -ResourceGroupName $ResourceGroupName -Force
If you had created a new resource group, remove the resource group.
Remove-AzResourceGroup -Name $ResourceGroupName -Force
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.