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 ...

Get ETL with Azure Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.