Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline

Intermediate
Data Engineer
Data Factory
Synapse Analytics

In this module, you will see how you can integrate SQL Server Integration Services packages into an Azure Data Factory solution

Learning objectives

  • Introduction
  • Describe SQL Server Integration Services
  • Understand the Azure-SIS integration runtime
  • Set-up Azure-SIS integration runtime
  • Run SSIS packages in Azure Data Factory
  • Migrate SSIS packages to Azure Data Factory
  • Knowledge check
  • Summary

Prerequisites

The student should be able to:

  • Log into the Azure portal
  • Explain and create resource groups
  • Describe Azure Data Factory and it's core components
  • Ingest data into Azure Data Factory using the Copy Activity