Andy Leonard
Andy Leonard is a data engineer, Data Philosopher, SSIS Trainer, Consultant, software developer, Biml developer, database and data warehouse developer, engineer, author, blogger, podcaster, dad, grandfather, and farmer.
SQLBits 2020
Faster SSIS
Learn tips and tricks to make SSIS perform better.
Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2019 Integration Services (SSIS 2019) packages.
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Prerequisites: Familiarity with SQL Server Integration Services (SSIS).