I am very happy to announce that I released my first course ‘Migrating SSIS Packages to ADF (Azure Data Factory)‘ (Lift-and-shift SSIS Packages to Azure Data Factory v2) on Pluralsight. I designed this course to be visually elegant.

These are the items covered in the Migrate SSIS Packages to ADF (Azure Data Factory) course:

Getting Started with Azure Data Factory

Just an introduction to ADF and why you need to Lift-and-shift SSIS packages to Azure Data Factory

Running SSIS Packages in Azure Data Factory

Different ways you can lift-and-shift SSIS Packages to ADF. Also how you can configure the pipeline with variables, parameters, etc)

Securing Data in Azure Data Factory

Learn about the security aspects of ADF migration (Azure Key Vault, Using Managed Identity, Service Principal authentication, etc)

Scheduling SSIS Packages in Azure Data Factory

Learn how you can schedule the SSIS packages in ADF (with schedule trigger, event-based trigger, tumbling window trigger, scheduling Azure SSIS Integration Runtime, etc)

Monitoring Azure Data Factory Pipelines

Here, once the data factory pipelines are operational, I discuss the different techniques to monitor the ADF pipelines

Full disclosure: Some of the links in this post are affiliate links. I earn commission if you purchase through them. This way you can support my blog at not extra cost to you!

Next steps (action items) for you before you take the course:

Watch the course trailer so you know what to expect

Migrating SSIS Packages to ADF

Some Screenshots/Video Clips from ‘Migrating SSIS Packages to ADF (Azure Data Factory)’ Course

How Azure Data Factory Works

Azure Data Factory v2 Integration Runtime (ADF IR)

Execute SSIS Packages That Connect to On-premises Data with Azure SSIS Integration Runtime

Blog post on executing SSIS Packages that connect to on-premises data with Azure SSIS Integration Runtime

Azure SQL DB vs. Managed Instance

Tumbling Window Triggers, and How They Work