Even in the most reliable ETL system, it’s eventually going to happen: A package will fail, an output row count won’t match what is expected, a data anomaly will force a forensic search of the package infrastructure… In this session, we’ll talk about some of the things that can go wrong during package execution – and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we’ll cover various ways to keep your ETL flowing when problems arise.
Tim Mitchell is a business intelligence architect, database developer, author, and trainer. He has been working with SQL Server for a decade, working primarily in business intelligence and training. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Tim is an independent business intelligence consultant in the Dallas, Texas area. He is the principal of Tyleris Data Solutions and is a Linchpin People teammate.