As a shift and lift, can we put 2010 SSIS package in azure blob and execute it using ADF?

Question

we have 2010 SSIS package as a file system.

we are planning to move azure as a shift and lift put in azure blob and run it using ADF

Question: can we put 2010 SSIS package in azure blob and execute it using ADF?

Can 2010 SSIS package run by ADF?

What is the list version of SSIS does ADF can execute?

Answer 1

Hi kiff ,
Welcome to Microsoft Q&A Forum, thank you for posting your query here!
Yes, you can move your 2010 SSIS package to Azure Blob Storage and execute it using Azure Data Factory (ADF). there are a few important considerations:

1. Azure-SSIS Integration Runtime: To run SSIS packages in ADF, you need to set up an Azure-SSIS Integration Runtime (IR). This is a managed cluster of virtual machines that can execute SSIS packages.
2. Package Compatibility: While you can upload your 2010 SSIS package to Azure Blob Storage, the Azure-SSIS IR is based on SQL Server 2017 or later. This means that your SSIS package will be upgraded to the 2017 version at runtime. Therefore, it is crucial to test your package after migration to ensure it runs correctly.
3. Supported Versions: ADF supports running SSIS packages from SQL Server 2012 and later2. Since your package is from 2010, you might need to upgrade it to a supported version before deploying it to Azure.

To execute your SSIS package in ADF:

1. Upload the Package: Place your SSIS package in Azure Blob Storage.
2. Create Azure-SSIS IR: Set up an Azure-SSIS Integration Runtime in ADF.
3. Deploy the Package: Deploy your SSIS package to the SSISDB catalog in Azure SQL Database or keep it in Azure Blob Storage.

• Create ADF Pipeline: Create a pipeline in ADF and use the Execute SSIS Package activity to run your package.
  For more information:

• https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-ssis-activity
• https://learn.microsoft.com/en-us/azure/data-factory/azure-ssis-integration-runtime-package-store

If you have any other questions or are still running into more issues, let me know in the "comments" and I would be happy to help you

---

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hello kiff,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you are concerned about shift and lift of your 2010 SSIS package to azure blob and execute it using ADF.

You can migrate your 2010 SSIS package to Azure and execute it using Azure Data Factory (ADF) by storing the package in Azure Blob Storage and utilizing the Azure-SSIS Integration Runtime (IR). Notice this: While ADF supports SSIS packages from SQL Server 2012 and later, your 2010 package will be automatically upgraded to the SSIS 2017 format at runtime. This ensures compatibility and allows you to leverage ADF for executing your existing SSIS packages.

For more details and clarification use these links: https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-ssis-activity and https://learn.microsoft.com/en-us/azure/data-factory/azure-ssis-integration-runtime-package-store

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.