Aaron Akin

January 3, 2009

SSIS Checkpoints with Event Handlers

Filed under: Checkpoints,Event Handlers,SQL 2005,SSIS — Aaron Akin @ 2:33 am

I recently had a project that required my package to utilize checkpoints, which wouldn’t have been a big deal, except this package had event handlers on some of the tasks.

Working with checkpoints never seems to be as straight forward and intuitive as you’d like it to be, and trying to implement them into a package that has event handlers can be quite frustrating (to say the least).

Since Microsoft BOL contains very limited documentation on the advanced uses of checkpoints in SSIS, I created a simple test package and played with as many properties as I could until I finally got the event handlers to work.

By the way, you can probably get around any of these problems by writing your own custom code, but I wanted to find out if it could be accomplished without using any custom logic (i.e. script tasks).

Here’s what I came up with…

Create a free website or blog at WordPress.com.