22-25 April 2026 
SQLBits 2019
How to Make Sure Your SSIS Packages Will Never Fail
If you never have errors in your SSIS packages, then you don't need to attend this session. But if you want your packages to be reliable and safe, and to handle errors appropriately, then this session is for you.
There are many methods and options in SSIS to handle errors during a
package execution. You can use event handlers, event propagation, package
transactions, precedence constraints, error rows, and more. Things get more
complicated when your package has multiple levels of containers, or even when
one package executes another. It is very easy (and common) to get lost and do
things the wrong way.
In this session we will learn about all the options available for us
to handle errors in SSIS, but more important – we will learn about the best
practices and the way to do it right.
package execution. You can use event handlers, event propagation, package
transactions, precedence constraints, error rows, and more. Things get more
complicated when your package has multiple levels of containers, or even when
one package executes another. It is very easy (and common) to get lost and do
things the wrong way.
In this session we will learn about all the options available for us
to handle errors in SSIS, but more important – we will learn about the best
practices and the way to do it right.
Speakers
Guy Glantser's previous sessions
The Most Important Performance Factor in SQL Server and Azure SQL
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
How to Make Sure Your SSIS Packages Will Never Fail
If you never have errors in your SSIS packages, then you don't need to attend this session. But if you want your packages to be reliable and safe, and to handle errors appropriately, then this session is for you.
Common Pitfalls When Analyzing Execution Plans
In this session you'll learn how to analyze execution plans efficiently, how to track the real bottleneck quickly, and how to avoid some common mistakes that will save you a lot of time and frustration…