How to use Azure-SSIS integration runtime to run SSIS packages in Azure and Azure Government


 

Integration runtime for Azure-SQL Server Integration Services (SSIS) makes it possible to simply run SSIS packages in Azure and Azure Government. The feature provides similar functionality and behavior to when you schedule SSIS packages by using SQL Server Agent in your on-prem environment. Azure Data Factory provides the engine to execute packages instead of SQL Server Integration Services. With this feature, you can run SSIS packages that are stored in SSISDB in a SQL Managed Instance, or a file system like Azure Files. The two additional components that are required for this feature along with Azure SQL Managed Instance or