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

  • Module
  • 8 Units
Intermediate
Data Engineer
Azure Data Factory
Azure Synapse Analytics

In this module, you'll 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 in to the Azure portal
  • Explain and create resource groups
  • Describe Azure Data Factory and its core components
  • Ingest data into Azure Data Factory using the Copy Activity