Manage an Azure-SSIS integration runtime
The Create an Azure-SSIS integration runtime article shows you how to create an Azure-SSIS integration runtime (IR) by using Azure Data Factory. This article provides information about reconfiguring an existing Azure-SSIS integration runtime.
This article applies to version 2 of Data Factory, which is currently in preview. If you are using version 1 of the Data Factory service, which is generally available (GA), see Data Factory version 1 documentation.
Data Factory UI
You can use Data Factory UI to stop, edit/reconfigure, or delete an Azure-SSIS IR.
- In the Data Factory UI, switch to the Edit tab. To launch Data Factory UI, click Author & Monitor on the home page of your data factory.
- In the left pane, click Connections.
- In the right pane, switch to the Integration Runtimes.
You can use buttons in the Actions column to stop, edit, or delete the integration runtime. The Code button in the Actions column lets you view the JSON definition associated with the integration runtime.
To reconfigure an Azure-SSIS IR
Stop the integration runtime by clicking Stop in the Actions column. To refresh the list view, click Refresh on the toolbar. After the IR is stopped, you see that the first action lets you start the IR.
- Edit/reconfigure IR by clicking Edit button in the Actions column. In the Integration Runtime Setup window, change settings (for example, size of the node, number of nodes, or maximum parallel executions per node).
- To restart the IR, click Start button in the Actions column.
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.
Reconfigure an Azure-SSIS IR
First, stop the Azure-SSIS integration runtime by using the Stop-AzureRmDataFactoryV2IntegrationRuntime cmdlet. This command releases all of its nodes and stops billing.
Stop-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName
Next, reconfigure the Azure-SSIS IR by using the Set-AzureRmDataFactoryV2IntegrationRuntime cmdlet. The following sample command scales out an Azure-SSIS integration runtime to five nodes.
Set-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -NodeCount 5
Then, start the Azure-SSIS integration runtime by using the Start-AzureRmDataFactoryV2IntegrationRuntime cmdlet. This command allocates all of its nodes for running SSIS packages.
Start-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName
Delete an Azure-SSIS IR
First, list all existing Azure SSIS IRs under your data factory.
Get-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -ResourceGroupName $ResourceGroupName -Status
Next, stop all existing Azure SSIS IRs in your data factory.
Stop-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
Next, remove all existing Azure SSIS IRs in your data factory one by one.
Remove-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
Finally, remove your data factory.
Remove-AzureRmDataFactoryV2 -Name $DataFactoryName -ResourceGroupName $ResourceGroupName -Force
If you had created a new resource group, remove the resource group.
Remove-AzureRmResourceGroup -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 an 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 (private preview) and joining the IR to a VNet.
- Join an Azure-SSIS IR to a VNet. This article provides conceptual information about joining an Azure-SSIS IR to an Azure virtual network (VNet). It also provides steps to use Azure portal to configure VNet so that Azure-SSIS IR can join the VNet.
- 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.