{"id":21197,"date":"2022-06-29T06:00:58","date_gmt":"2022-06-29T13:00:58","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azuregov\/?p=21197"},"modified":"2022-06-29T06:12:52","modified_gmt":"2022-06-29T13:12:52","slug":"how-to-use-azure-ssis-integration-runtime-to-run-ssis-packages-in-azure-and-azure-government","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azuregov\/how-to-use-azure-ssis-integration-runtime-to-run-ssis-packages-in-azure-and-azure-government\/","title":{"rendered":"How to use Azure-SSIS integration runtime to run SSIS packages in Azure and Azure Government"},"content":{"rendered":"<p>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.<\/p>\n<p>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 an Azure SQL database, and SSMS are Azure Data Factory and Integration Runtime for Azure SSIS.<\/p>\n<ol>\n<li>Create Azure Data Factory (ADF).<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/quickstart-create-data-factory-portal\">Documentation<\/a> on how to create Azure Data Factory.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"2\">\n<li>Create Integration Runtime (IR) for Azure-SSIS.<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/tutorial-deploy-ssis-packages-azure\">Documentation<\/a> on provisioning the Azure-SSIS IR in ADF.<\/li>\n<li>Specify where your packages will be hosted.\n<ul>\n<li>Click \u201cCreate SSIS catalog (SSISDB) hosted by Azure SQL&#8230;\u201d to host your packages in SSISDB on an Azure SQL Db or an Azure SQL Managed Instance. This option will create SSISDB in the Azure SQL MI.<\/li>\n<li>Click \u201cCreate package store to manage your packages to host your packages into Azure files, or MSDB. You will need a file share created in a storage account.<\/li>\n<\/ul>\n<\/li>\n<li>Once created, the IR will take a few minutes to start.<\/li>\n<li>The location (region) of your Azure-SSIS IR should be the same as the location (region) of the SSIDB on Azure SQL DB or Azure SQL Managed Instance to minimize cross-location traffic.<\/li>\n<li>The following table shows the options available to you depending on where you want to host your packages.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-10-Table.png\"><img decoding=\"async\" class=\"wp-image-21214 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-10-Table-290x300.png\" alt=\"Image SSIS Image 10 8211 Table\" width=\"501\" height=\"518\" srcset=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-10-Table-290x300.png 290w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-10-Table-768x794.png 768w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-10-Table-24x24.png 24w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-10-Table.png 970w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/a><\/p>\n<ol start=\"3\">\n<li>Assess SSIS packages with Database Migration Assistant.<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/dma\/dma-assess-ssis?view=sql-server-ver15\">Documentation<\/a> on performing a SSIS migration assessment with DMA.<\/li>\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53595\">Download DMA<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"4\">\n<li>Import projects to Azure SQL MI.<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Only project deployment model supported with SSIS in ADF.\n<ul>\n<li>Export your packages as .ispac files and move them to a location where your Azure SQL MI can import them from.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"5\">\n<li>Configure packages with new connections.<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Connection properties can be edited in SSMS or ADF.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol start=\"6\">\n<li>Schedule package execution in ADF.<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Open ADF Studio to create a pipeline to execute\/schedule your SSIS package.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-5.png\"><img decoding=\"async\" class=\"wp-image-21206 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-5-300x202.png\" alt=\"Image SSIS Image 5\" width=\"500\" height=\"337\" srcset=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-5-300x202.png 300w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-5.png 750w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Under \u201cGeneral\u201d tab, give the activity a meaningful name. Click on \u201cSettings\u201d tab, pick the Azure-SSIS IR created earlier, then navigate to the target package.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-6.png\"><img decoding=\"async\" class=\"wp-image-21205 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-6-300x234.png\" alt=\"Image SSIS Image 6\" width=\"499\" height=\"389\" srcset=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-6-300x234.png 300w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-6.png 750w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>You can edit the connection properties under \u201cConnection managers\u2019 tab. Click on \u201cDebug\u201d to run the pipeline. Click on \u201cAdd trigger\u201d to schedule the pipeline. Click on \u201cProperties\u201d to give the pipeline a meaningful name.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-7.png\"><img decoding=\"async\" class=\"wp-image-21204 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-7-300x149.png\" alt=\"Image SSIS Image 7\" width=\"499\" height=\"248\" srcset=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-7-300x149.png 300w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-7.png 750w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><\/a><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Configure a Trigger to set a schedule for the pipeline.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8.png\"><img decoding=\"async\" class=\"wp-image-21203 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8-300x297.png\" alt=\"Image SSIS Image 8\" width=\"500\" height=\"495\" srcset=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8-300x297.png 300w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8-150x150.png 150w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8-24x24.png 24w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8-48x48.png 48w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8-96x96.png 96w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-8.png 750w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<ol start=\"7\">\n<li>Set up alerts in ADF by creating a new alert, adding criteria, alert logic and notifications.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-9.png\"><img decoding=\"async\" class=\"wp-image-21202 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-9-300x123.png\" alt=\"Image SSIS Image 9\" width=\"500\" height=\"205\" srcset=\"https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-9-300x123.png 300w, https:\/\/devblogs.microsoft.com\/azuregov\/wp-content\/uploads\/sites\/43\/2022\/06\/SSIS-Image-9.png 750w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><strong>Learn more<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/concepts-integration-runtime#azure-ssis-integration-runtime\">Integration runtime &#8211; Azure Data Factory &amp; Azure Synapse | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/tutorial-deploy-ssis-packages-azure\">Provision the Azure-SSIS integration runtime &#8211; Azure Data Factory | Microsoft Docs<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":94920,"featured_media":21220,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,14],"tags":[75,2083,95,316,524,3467],"class_list":["post-21197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azuregov","category-learning","tag-azure","tag-azure-data-factory","tag-azure-government","tag-government-cloud","tag-sql-azure","tag-ssis"],"acf":[],"blog_post_summary":"<p>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 [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/21197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/users\/94920"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/comments?post=21197"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/21197\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media\/21220"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media?parent=21197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/categories?post=21197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/tags?post=21197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}