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

Posted by James Luetkehoelter on SQL Blog See other posts from SQL Blog or by James Luetkehoelter
Published on Thu, 17 Jun 2010 20:24:00 GMT Indexed on 2010/06/17 21:34 UTC
Read the original article Hit count: 397

Filed under:

ssis

|

What were you thinking?

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... Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

Related posts about What were you thinking?

Search french via Thinking Sphinx in ROR project

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone: How can I use sphinx to search french words which the entries in the db is actually english? The situation is: I have a ROR project with a table in the db called "categories", and the category names are in english, category has many "question" entries. In localization file config/locals/fr… >>> More
Thinking Sphinx not working in test mode

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to get Thinking Sphinx to work in test mode in Rails. Basically this: ThinkingSphinx::Test.init ThinkingSphinx::Test.start freezes and never comes back. My test and devel configuration is the same for test and devel: dry_setting: &dry_setting adapter: mysql host: localhost … >>> More
Teaching logical/analytical thinking

as seen on Programmers - Search for 'Programmers'
I have been trial running a club in which I teach programming for the past year and while they have progressed what they really lack is the most fundamental concept to programming, analytical thinking. As I now approach the second year of teaching to the children (aged 12 - 14) I am now realising… >>> More
Subaru Starts Thinking about their Path to Fusion Applications

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Brian Simmermon, VP and CIO, Subaru of America, and a member of Oracle's Fusion Strategy Council explains how Subaru is aligning their business and IT strategy to improve sales through Siebel and EBS, and is looking at implementing Fusion Technologies such as BPEL, AIA and Enterprise Manager to begin… >>> More
The Disloyalty Card

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Let's take a break from technology for a second; please indulge me. (That's for you Erick.) A few months back, James Hoffmann reported that Gwilym Davies, the 2009 World Barista Champion, had implemented a rather unique idea for his cafe: the disloyalty card. His card lists eight nearby cafes in… >>> More

Developer IT

How not to handle a compensation step on failure in an SSIS package - Developer IT

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

ssis

What were you thinking?

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

Parsing flat files using SSIS : SSIS Nugget

Introducing SSIS Reporting Pack for SQL Server code-named Denali

New SSIS tool on Codeplex – SSIS Log Analyzer

New SSIS tool on Codeplex – SSIS Log Analyzer

Related posts about What were you thinking?

Search french via Thinking Sphinx in ROR project

Thinking Sphinx not working in test mode

Teaching logical/analytical thinking

Subaru Starts Thinking about their Path to Fusion Applications

The Disloyalty Card

Categories cloud