Chapter 8: SSIS Migration Strategies
Many enterprises are in the process of migrating some of their on-premises SQL Server Integration Services (SSIS) solutions to the Azure cloud these days. There are lots of Extract, Transform, Load (ETL) to migrate and the cloud can represent a challenge on that front.
There are two basic strategies to migrate SSIS packages to Azure: run them as they are or re-write them. We'll explore both options in this chapter.
In this chapter, we will cover the following recipes:
- Running SSIS packages in ADF
- Rewriting an SSIS package using ADF
By the end of this chapter, you will have an understanding of how to handle SSIS package migration to Azure.
Running SSIS packages in ADF
Data Factory provides a way to run ...