| title | description | ms.service | ms.subservice | ms.topic | ms.date | author | ms.author | ms.custom |
|---|---|---|---|---|---|---|---|---|
Deploy SSIS packages |
Learn how to deploy and run SSIS packages in Azure Data Factory with the Azure-SSIS integrated runtime. |
data-factory |
integration-services |
conceptual |
10/22/2021 |
swinarko |
sawinark |
devx-track-azurepowershell |
After configuration of your Azure-SSIS integration runtime, you can deploy and run packages in Azure directly.
If you use SSISDB, you can deploy your packages into it and run them on your Azure-SSIS IR by using the Azure-enabled SSDT or SSMS tools. These tools connect to your database server via its server endpoint:
- For an Azure SQL Database server, the server endpoint format is
<server name>.database.windows.net. - For a managed instance with private endpoint, the server endpoint format is
<server name>.<dns prefix>.database.windows.net. - For a managed instance with public endpoint, the server endpoint format is
<server name>.public.<dns prefix>.database.windows.net,3342.
If you don't use SSISDB, you can deploy your packages into file system, Azure Files, or MSDB hosted by your Azure SQL Managed Instance and run them on your Azure-SSIS IR by using dtutil and AzureDTExec command-line utilities.
For more information, see Deploy SSIS projects/packages.
In both cases, you can also run your deployed packages on Azure-SSIS IR by using the Execute SSIS Package activity in Data Factory pipelines. For more information, see Invoke SSIS package execution as a first-class Data Factory activity.
- Learn how to provision an Azure-SSIS IR using the Azure portal.
- Learn how to provision an Azure-SSIS IR using Azure PowerShell.
- Learn how to provision an Azure-SSIS IR using an Azure Resource Manager template.
See other Azure-SSIS IR topics in this documentation:
- Azure-SSIS integration runtime. This article provides information about integration runtimes in general, including Azure-SSIS IR.
- Monitor an Azure-SSIS IR. This article shows you how to retrieve and understand information about your Azure-SSIS IR.
- Manage an Azure-SSIS IR. This article shows you how to stop, start, or delete your Azure-SSIS IR. It also shows you how to scale out your Azure-SSIS IR by adding more nodes.
- Deploy, run, and monitor SSIS packages in Azure
- Connect to SSISDB in Azure
- Connect to on-premises data sources with Windows authentication
- Schedule package executions in Azure