James Luetkehoelter : SSIShttp://sqlblog.com/blogs/james_luetkehoelter/archive/tags/SSIS/default.aspxTags: SSISenCommunityServer 2.1 SP2 (Build: 61129.1)How *not* to handle a compensation step on failure in an SSIS packagehttp://sqlblog.com/blogs/james_luetkehoelter/archive/2010/06/17/how-not-to-handle-a-compensation-step-on-failure-in-an-ssis-package.aspxThu, 17 Jun 2010 21:34:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:26252James Luetkehoelter0http://sqlblog.com/blogs/james_luetkehoelter/comments/26252.aspxhttp://sqlblog.com/blogs/james_luetkehoelter/commentrss.aspx?PostID=26252Just stumbed across this where I'm working. Someone created a global error handler for a package that included this SQL step: DELETE FROM Table WHERE DateDiff(MI, ExportedDate, GetDate()) &lt; 5 So if the package runs for longer than 5 minutes and fails,...(<a href="http://sqlblog.com/blogs/james_luetkehoelter/archive/2010/06/17/how-not-to-handle-a-compensation-step-on-failure-in-an-ssis-package.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=26252" width="1" height="1">SSISWhat were you thinking?