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

Comments

No Comments
New Comments to this post are disabled

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.
Privacy Statement