The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

Running SSIS 2017 at Scale Everywhere

Description

See how to use the latest SSIS 2017 to modernize your traditional on-premises ETL workflows and transform them into scalable hybrid ETL/ELT workflows.

First, we will take a deep dive into SSIS Scale-Out feature, guiding you end-to-end from cluster installations to parallel executions on premises/IaaS, to help shorten the overall duration of your workflows.  Next, we will guide you to lift & shift your ETL workloads into SSIS PaaS in ADFv2.  Finally, we will show you how to trigger/schedule/orchestrate SSIS package executions in ADF pipelines.

Pre-requisites
Know about/have used SSIS before.
Laptop Required:No

Learning Objectives

Previous Experience

Tech Covered

SSIS, ETL