You can now use Azure-SSIS Integration Runtime (IR) and Execute SSIS package activity in Azure Synapse Analytics.
An Azure-SSIS IR in Azure Synapse Analytics supports
You can deploy your packages into Azure Files (Package Deployment Model).
If you use SSISDB (Project Deployment Model), you can deploy your packages into SSISDB hosted in Azure SQL Managed Instance or Azure SQL Database with the Deployment Wizard. In the Select Deployment Target step, choosing SSIS in Azure Data Factory. Then enter the 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.
Deployment target as SSIS in Azure Synapse Analytics is not available currently.
To deploy SSIS project to SSIS IR in Azure Synapse Analytics, in the Select Deployment Target step, choose SSIS in Azure Data Factory instead. Then enter the destination server name (Azure SQL Database or Azure SQL Managed Instance) where the project will be in the Integration Services Catalog.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.