THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Downloads   Opml View as RSS news feed in XML

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

Leave a Comment

(required) 
(optional)
(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.

This Blog

Syndication
©2006-2010 SQLblog.comTM
Brought to you by Adam Machanic & Peter DeBetta
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement