THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search
Home Blogs 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

Comments

No Comments

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.

This Blog

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