ETL platforms come and go, but SQL Server Integration Services (SSIS) stands strong against the test of time. It is versatile, maximizes the benefits of parallel processing, and offers an intuitive designer for building out workflows that can be both effective and beautiful to behold. In this session, we’ll cover the essentials: what SSIS can do, the wide range of tasks it supports, and how it tackles modern-day challenges. Using IMDb data, we’ll explore importing, analyzing, and transforming data into a relational database. From a collection of files to a robust data set, we’ll demonstrate how tasks can join, split, calculate, and sanitize data to produce effective and efficient real-world data integration. Be prepared to leave with a strong desire and the skills needed to replace those dusty, inefficient processes with packages that are both streamlined and elegant.