THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

James Luetkehoelter

Nearly any SQL topic presented at times in a slightly eclectic manner.

How *not* to handle a compensation step on failure in an SSIS package

Just 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()) < 5

So if the package runs for longer than 5 minutes and fails, nothing gets cleaned up. Please people, don't do this...

Published Thursday, June 17, 2010 5:34 PM by James Luetkehoelter

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

prohibitive said:

James Luetkehoelter : How *not* to handle a compensation step on failure in an SSIS package

October 6, 2014 11:55 PM
 

perturbed said:

James Luetkehoelter : How *not* to handle a compensation step on failure in an SSIS package

October 12, 2014 4:26 AM

Leave a Comment

(required) 
(required) 
Submit

About James Luetkehoelter

I am passionate about what I do - which is DBA, development, IT and IT business consulting. If you don't know me, haven't met me or have never heard me speak, I'm a little on the eccentric side. One attendee recently described me as being "over the top". Yup, that about says it - because I only speak on topics that I'm passionate about.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement