This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.
You can now use SSIS Integration Runtime and Execute SSIS package activity in Azure Synapse Analytics.
An Azure-SSIS IR in Azure Synapse Analytics supports
- Running packages deployed into SSIS catalog (SSISDB) hosted by Azure SQL Database server/Managed Instance (Project Deployment Model)
- Running packages deployed into Azure Files (Package Deployment Model)
Create an Azure-SSIS integration runtime
- In the Synapse workspace portal, switch to the Manage tab and then switch to the Integration runtimes to view existing integration, then select New to create a new Azure-SSIS IR and open the Integration runtime setup pane
- In the Integration runtime setup pane, select the Lift-and-shift existing SSIS packages to execute in Azure tile, and then select Continue.
- For the remaining steps to set up an Azure-SSIS IR, see the Provision an Azure SSIS integration runtime section.
Execute SSIS Package activity in Synapse pipelines
You can deploy your packages into Azure Files (Package Deployment Model).
If you use SSISDB (Project Deployment Model), you can deploy your packages into it SSISDB hosted in Azure SQL Managed Instance or Azure SQL Database with the Deployment Wizard. In step Select Deployment Target, choosing “SSIS in Azure Data Factory”, then enter destination server name (Azure SQL Database or Azure SQL Managed Instance) where the project will be located in the Integration Services Catalog.
In both cases, you can also run your deployed packages on Azure-SSIS IR by using the Execute SSIS Package activity in Synapse pipelines. For more information, see Invoke SSIS package execution as a first-class activity.
Limitations and known issues
Deployment target as SSIS in Azure Synapse Analytics is not available currently.
To deploy SSIS project to SSIS IR in Azure Synapse Analytics, in step Select Deployment Target, choosing “SSIS in Azure Data Factory” instead, then enter destination server name (Azure SQL Database or Azure SQL Managed Instance) where the project will be in the Integration Services Catalog.
- Pricing is the same as in Data Factory, refer to SQL Server Integration Pricing in Azure Data Factory.
- Below features are not available for SSIS IR in Azure Synapse: