I’m happy to announce that I will be speaking at the SQL PASS Summit this fall. The summit will be held during the first week of November in Seattle, Washington. This will be my seventh year attending the PASS Summit, and my fourth year as a speaker.
This year I will be delivering a new presentation entitled “Building Bullet-Resistant SSIS Packages”:
It’s 2:30 a.m., and you’ve just gotten that call no ETL developer wants to get: an SSIS package has failed unexpectedly. Immediately, you start asking yourself: “What could have caused this?”, “What do I do to fix the data from this failed execution?”, and, most importantly, “Could I design the package in such a way that this doesn’t happen again?”
In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we’ll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We’ll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.
I’m looking forward to presenting this session, but more importantly, I’m excited about meeting new community members and catching up with #sqlfamily. I hope to see you in Seattle in November!