See how to use the latest SQL Server Integration Services (SSIS) 2017 to modernize traditional on-premises ETL workflows, transforming them into scalable hybrid ETL/ELT workflows in preparation for Big Data Analytics workloads in the cloud. We will showcase the latest additions to SSIS Azure Feature Pack, introducing/improving connectivity components for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), and Azure HDInsight (HDI).  We will also take a deep dive into SSIS Scale-Out feature, guiding you end-to-end from cluster installation to parallel execution, to help reduce the overall runtime of your workflows.  Finally, we will show you how to execute the SSIS packages on Azure as PaaS via Azure Data Factory V2.
Presented by Jimmy Wong at SQLBits XVII
MP4 Video Low 530 MB
MP4 Video Med 967 MB
MP4 Video High 1,501 MB
MP4 Video HD 2,835 MB