22-25 April 2026
Book Now

Running SSIS 2017 at Scale Everywhere

2018

TL; DR

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.

Session Details

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

3 things you'll get out of this session

Speakers

Sandy Winarko

techcommunity.microsoft.com/t5/sql-server-integration-services/bg-p/SSIS

Sandy Winarko's previous sessions

Deeper Integration and New Transformation for SSIS in ADF
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
 
What’s New with SSIS in ADFv2
See the latest features of SSIS in ADFv2, e.g. ARM VNet, Enterprise Edition, Custom Setup Interface, Execute SSIS Package Activity, etc.