Azure-SSIS Integration Runtime now available in Azure Synapse Analytics (Public Preview)

Published Feb 15 2022 09:57 PM 4,525 Views
Microsoft

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

  • 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

  1. In the Synapse workspace portal, switch to the Manage tab and then switch to the Integration runtimes to view existing integration. Select New to create a new Azure-SSIS IR and open the Integration runtime setup pane

Chunhua_0-1644990695810.png

 

  1. In the Integration runtime setup pane, select the Lift-and-shift existing SSIS packages to execute in Azure tile, and then select Continue.

Chunhua_1-1644990695815.png

 

  1. For the remaining steps to set up an Azure-SSIS IR, see the Provision an Azure SSIS integration runtime process.

 

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 SSISDB hosted in Azure SQL Managed Instance or Azure SQL Database with the Deployment Wizard. In the Select Deployment Target stepchoosing 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. 

 

Chunhua_2-1644990695821.png

 

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.

 

Chunhua_3-1644990695827.png

 

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 the Select Deployment Target stepchoose 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.  

 

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3171763%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EAzure-SSIS%20Integration%20Runtime%20is%20available%20in%20Azure%20Synapse%20Analytics%20(Public%20Preview)%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3171763%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EYou%20can%20now%20use%20SSIS%20Integration%20Runtime%20and%20Execute%20SSIS%20package%20activity%20in%20Azure%20Synapse%20Analytics.%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3EAn%20Azure-SSIS%20IR%20in%20Azure%20Synapse%20Analytics%20supports%26lt%3B%5C%2FP%26gt%3B%5Cn%3CUL%3E%5Cn%3CLI%3ERunning%20packages%20deployed%20into%20SSIS%20catalog%20(SSISDB)%20hosted%20by%20Azure%20SQL%20Database%20server%2FManaged%20Instance%20(Project%20Deployment%20Model)%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FLI%3E%3CLI%3ERunning%20packages%20deployed%20into%20Azure%20Files%20(Package%20Deployment%20Model)%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%5Cn%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CH2%20id%3D%22%5C%26quot%3Btoc-hId-365042332%5C%26quot%3B%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%3ECreate%20an%20Azure-SSIS%20integration%20runtime%26lt%3B%5C%2FH2%26gt%3B%5Cn%3COL%3E%5Cn%3CLI%3EIn%20the%20Synapse%20workspace%20portal%2C%20switch%20to%20the%26nbsp%3B%3CSTRONG%3EManage%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Btab%20and%20then%20switch%20to%20the%26nbsp%3B%3CSTRONG%3EIntegration%20runtimes%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Bto%20view%20existing%20integration%2C%20then%20select%26nbsp%3B%3CSTRONG%3ENew%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Bto%20create%20a%20new%20Azure-SSIS%20IR%20and%20open%20the%26nbsp%3B%3CSTRONG%3EIntegration%20runtime%20setup%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Bpane%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348598i083B89AA6F314388%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Chunhua_0-1644990695810.png%22%20alt%3D%22%5C%26quot%3BChunhua_0-1644990695810.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3COL%20start%3D%22%5C%26quot%3B2%5C%26quot%3B%22%3E%5Cn%3CLI%3EIn%20the%26nbsp%3B%3CSTRONG%3EIntegration%20runtime%20setup%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Bpane%2C%20select%20the%26nbsp%3B%3CSTRONG%3ELift-and-shift%20existing%20SSIS%20packages%20to%20execute%20in%20Azure%26lt%3B%5C%2FSTRONG%26gt%3B%26nbsp%3Btile%2C%20and%20then%20select%26nbsp%3B%3CSTRONG%3EContinue%26lt%3B%5C%2FSTRONG%26gt%3B.%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348597i3560EB4265546A8D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Chunhua_1-1644990695815.png%22%20alt%3D%22%5C%26quot%3BChunhua_1-1644990695815.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3COL%20start%3D%22%5C%26quot%3B3%5C%26quot%3B%22%3E%5Cn%3CLI%3EFor%20the%20remaining%20steps%20to%20set%20up%20an%20Azure-SSIS%20IR%2C%20see%20the%26nbsp%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcreate-azure-ssis-integration-runtime-portal%23provision-an-azure-ssis-integration-runtime%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EProvision%20an%20Azure%20SSIS%20integration%20runtime%26lt%3B%5C%2FA%26gt%3B%26nbsp%3Bsection.%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CH2%20id%3D%22%5C%26quot%3Btoc-hId--1442412131%5C%26quot%3B%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%20id%3D%22toc-hId-365042337%22%3EExecute%20SSIS%20Package%20activity%20in%20Synapse%20pipelines%26lt%3B%5C%2FH2%26gt%3B%5Cn%3CP%3EYou%20can%20deploy%20your%20packages%20into%20Azure%20Files%20(Package%20Deployment%20Model).%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3EIf%20you%20use%20SSISDB%20(Project%20Deployment%20Model)%2C%20you%20can%20%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Flift-shift%2Fssis-azure-deploy-run-monitor-tutorial%3Fview%3Dsql-server-ver15%23deploy-a-project-with-the-deployment-wizard%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3Edeploy%20your%20packages%20into%20it%20SSISDB%20hosted%20in%20Azure%20SQL%20Managed%20Instance%20or%20Azure%20SQL%20Database%20with%20the%20Deployment%20Wizard%26lt%3B%5C%2FA%26gt%3B.%20%26nbsp%3BIn%20step%20%3CSTRONG%3ESelect%20Deployment%20Target%2C%20%26lt%3B%5C%2FSTRONG%26gt%3Bchoosing%20%E2%80%9C%3CSTRONG%3ESSIS%20in%20Azure%20Data%20Factory%26lt%3B%5C%2FSTRONG%26gt%3B%E2%80%9D%2C%20then%20enter%20destination%20server%20name%20(Azure%20SQL%20Database%20or%20Azure%20SQL%20Managed%20Instance)%20where%20the%20project%20will%20be%20located%20in%20the%20Integration%20Services%20Catalog.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348599i3DB14A8055E20C21%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Chunhua_2-1644990695821.png%22%20alt%3D%22%5C%26quot%3BChunhua_2-1644990695821.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3EIn%20both%20cases%2C%20you%20can%20also%20run%20your%20deployed%20packages%20on%20Azure-SSIS%20IR%20by%20using%20the%20%3CSTRONG%3EExecute%20SSIS%20Package%20activity%26lt%3B%5C%2FSTRONG%26gt%3B%20in%20Synapse%20pipelines.%20For%20more%20information%2C%20see%26nbsp%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssis-activity%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EInvoke%20SSIS%20package%20execution%20as%20a%20first-class%20activity%26lt%3B%5C%2FA%26gt%3B.%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348600i6A4C2A1DA9435665%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Chunhua_3-1644990695827.png%22%20alt%3D%22%5C%26quot%3BChunhua_3-1644990695827.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3C%2FH2%3E%3CH2%20id%3D%22%5C%26quot%3Btoc-hId-1045100702%5C%26quot%3B%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%20id%3D%22toc-hId--1442412126%22%3ELimitations%20and%20known%20issues%26lt%3B%5C%2FH2%26gt%3B%5Cn%3CUL%3E%5Cn%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Flift-shift%2Fssis-azure-deploy-run-monitor-tutorial%3Fview%3Dsql-server-ver15%23deploy-a-project-with-the-deployment-wizard%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EDeploy%20a%20project%20with%20the%20Deployment%20Wizard%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%5Cn%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3EDeployment%20target%20as%20SSIS%20in%20Azure%20Synapse%20Analytics%20is%20not%20available%20currently.%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3ETo%20deploy%20SSIS%20project%20to%20SSIS%20IR%20in%20Azure%20Synapse%20Analytics%2C%20in%20step%20%3CSTRONG%3ESelect%20Deployment%20Target%2C%20%26lt%3B%5C%2FSTRONG%26gt%3Bchoosing%20%E2%80%9C%3CSTRONG%3ESSIS%20in%20Azure%20Data%20Factory%26lt%3B%5C%2FSTRONG%26gt%3B%E2%80%9D%20instead%2C%20then%20enter%20destination%20server%20name%20(Azure%20SQL%20Database%20or%20Azure%20SQL%20Managed%20Instance)%20where%20the%20project%20will%20be%20in%20the%20Integration%20Services%20Catalog.%20%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3CUL%3E%5Cn%3CLI%3EPricing%20is%20the%20same%20as%20in%20Data%20Factory%2C%20refer%20to%20%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fpricing%2Fdetails%2Fdata-factory%2Fssis%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3ESQL%20Server%20Integration%20Pricing%20in%20Azure%20Data%20Factory%26lt%3B%5C%2FA%26gt%3B.%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%5Cn%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3CUL%3E%5Cn%3CLI%3EBelow%20features%20are%20not%20available%20for%20SSIS%20IR%20in%20Azure%20Synapse%3A%3CUL%3E%5Cn%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssdt%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3ESSDT%20(Azure-enabled)%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssdt%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fmonitor-ssis%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EMonitor%20SSIS%20operations%20with%20Azure%20Monitor%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fmonitor-ssis%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fenable-aad-authentication-azure-ssis-ir%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EAzure%20AD%20authentication%20with%20user-assigned%20managed%20identity%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fenable-aad-authentication-azure-ssis-ir%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Ftutorial-push-lineage-to-purview%23run-pipeline-and-push-lineage-data-to-azure-purview%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EPush%20Azure-SSIS%20IR%20lineage%20data%20to%20Azure%20Purview%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Ftutorial-push-lineage-to-purview%23run-pipeline-and-push-lineage-data-to-azure-purview%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fazure-ssis-integration-runtime-package-store%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EManage%20packages%20with%20Azure-SSIS%20Integration%20Runtime%20package%20store%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fazure-ssis-integration-runtime-package-store%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-migrate-ssis-job-ssms%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EMigrate%20SSIS%20jobs%20with%20SSMS%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-migrate-ssis-job-ssms%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-azure-enabled-dtexec%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3EAzure-enabled%20dtexec%20utility%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%5Cn%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FP%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FP%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FH2%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FP%3E%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FP%3E%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FH2%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3171763%22%20slang%3D%22en-US%22%3EAzure-SSIS%20Integration%20Runtime%20now%20available%20in%20Azure%20Synapse%20Analytics%20(Public%20Preview)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3171763%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20now%20use%20Azure-SSIS%20Integration%20Runtime%20(IR)%20and%20Execute%20SSIS%20package%20activity%20in%20Azure%20Synapse%20Analytics.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20Azure-SSIS%20IR%20in%20Azure%20Synapse%20Analytics%20supports%3C%2FP%3ERunning%20packages%20deployed%20into%20SSIS%20catalog%20(SSISDB)%20hosted%20by%20Azure%20SQL%20Database%20server%2FManaged%20Instance%20(Project%20Deployment%20Model)%20Running%20packages%20deployed%20into%20Azure%20Files%20(Package%20Deployment%20Model)%3CP%3E%26nbsp%3B%3C%2FP%3ECreate%20an%20Azure-SSIS%20integration%20runtime%20In%20the%20Synapse%20workspace%20portal%2C%20switch%20to%20the%26nbsp%3BManage%26nbsp%3Btab%20and%20then%20switch%20to%20the%26nbsp%3BIntegration%20runtimes%26nbsp%3Bto%20view%20existing%20integration.%20Select%26nbsp%3BNew%26nbsp%3Bto%20create%20a%20new%20Azure-SSIS%20IR%20and%20open%20the%26nbsp%3BIntegration%20runtime%20setup%26nbsp%3Bpane%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3EIn%20the%26nbsp%3BIntegration%20runtime%20setup%26nbsp%3Bpane%2C%20select%20the%26nbsp%3BLift-and-shift%20existing%20SSIS%20packages%20to%20execute%20in%20Azure%26nbsp%3Btile%2C%20and%20then%20select%26nbsp%3BContinue.%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3EFor%20the%20remaining%20steps%20to%20set%20up%20an%20Azure-SSIS%20IR%2C%20see%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcreate-azure-ssis-integration-runtime-portal%23provision-an-azure-ssis-integration-runtime%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EProvision%20an%20Azure%20SSIS%20integration%20runtime%3C%2FA%3E%26nbsp%3Bprocess.%3CP%3E%26nbsp%3B%3C%2FP%3EExecute%20SSIS%20Package%20activity%20in%20Synapse%20pipelines%3CP%3EYou%20can%20deploy%20your%20packages%20into%20Azure%20Files%20(Package%20Deployment%20Model).%3C%2FP%3E%3CP%3EIf%20you%20use%20SSISDB%20(Project%20Deployment%20Model)%2C%20you%20can%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Flift-shift%2Fssis-azure-deploy-run-monitor-tutorial%3Fview%3Dsql-server-ver15%23deploy-a-project-with-the-deployment-wizard%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3Edeploy%20your%20packages%20into%20SSISDB%20hosted%20in%20Azure%20SQL%20Managed%20Instance%20or%20Azure%20SQL%20Database%3C%2FA%3E%20with%20the%20Deployment%20Wizard.%20In%20the%26nbsp%3BSelect%20Deployment%20Target%20step%2C%26nbsp%3Bchoosing%20SSIS%20in%20Azure%20Data%20Factory.%26nbsp%3BThen%20enter%20the%20destination%20server%20name%20(Azure%20SQL%20Database%20or%20Azure%20SQL%20Managed%20Instance)%20where%20the%20project%20will%20be%20located%20in%20the%20Integration%20Services%20Catalog.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20both%20cases%2C%20you%20can%20also%20run%20your%20deployed%20packages%20on%20Azure-SSIS%20IR%20by%20using%20the%20Execute%20SSIS%20Package%20activity%20in%20Synapse%20pipelines.%20For%20more%20information%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssis-activity%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EInvoke%20SSIS%20package%20execution%20as%20a%20first-class%20activity%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3ELimitations%20and%20known%20issues%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Flift-shift%2Fssis-azure-deploy-run-monitor-tutorial%3Fview%3Dsql-server-ver15%23deploy-a-project-with-the-deployment-wizard%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EDeploy%20a%20project%20with%20the%20Deployment%20Wizard%3C%2FA%3E%3CP%3EDeployment%20target%20as%20SSIS%20in%20Azure%20Synapse%20Analytics%20is%20not%20available%20currently.%3C%2FP%3E%3CP%3ETo%20deploy%20SSIS%20project%20to%20SSIS%20IR%20in%20Azure%20Synapse%20Analytics%2C%20in%20the%26nbsp%3BSelect%20Deployment%20Target%20step%2C%26nbsp%3Bchoose%20SSIS%20in%20Azure%20Data%20Factory%26nbsp%3Binstead.%20Then%20enter%20the%20destination%20server%20name%20(Azure%20SQL%20Database%20or%20Azure%20SQL%20Managed%20Instance)%20where%20the%20project%20will%20be%20in%20the%20Integration%20Services%20Catalog.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3EBelow%20features%20are%20not%20available%20for%20SSIS%20IR%20in%20Azure%20Synapse%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssdt%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3ESSDT%20(Azure-enabled)%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fmonitor-ssis%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EMonitor%20SSIS%20operations%20with%20Azure%20Monitor%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Ftutorial-push-lineage-to-purview%23run-pipeline-and-push-lineage-data-to-azure-purview%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EPush%20Azure-SSIS%20IR%20lineage%20data%20to%20Azure%20Purview%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fazure-ssis-integration-runtime-package-store%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EManage%20packages%20with%20Azure-SSIS%20Integration%20Runtime%20package%20store%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-migrate-ssis-job-ssms%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EMigrate%20SSIS%20jobs%20with%20SSMS%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-azure-enabled-dtexec%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EAzure-enabled%20dtexec%20utility%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3171763%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20now%20use%20Azure-SSIS%20Integration%20Runtime%20(IR)%20and%20Execute%20SSIS%20package%20activity%20in%20Azure%20Synapse%20Analytics.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎Mar 06 2022 10:44 PM
Updated by: