THE SQL Server Blog Spot on the Web

Welcome to - 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:

   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


No Comments

Leave a Comment


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