Reliably stopping a package that has been loaded and run programmatically. -
08-27-2004
, 03:00 PM
As part of an extended protection, I want to reliably stop a package's
execution, programmatically, if it is taking too long, due to a problem.
I see the OnQueryCancel event provided, which is intended for this, and
have logged it a bit, to see what it does. It does not seem to fire
while ActiveX scripts are running. My guess is that it MIGHT not fire
during a deadlock scenario either?
In trying to protect against infinite loops in script, and deadlocks, my
fear is that the OnQueryCancel event may never fire when I need it most,
and so, may not be reliable for the recovery scenarios I am attempting.
Seeking the wisdom of others who have already considered or worked with
this.
Should I be trying to additionally do something more abortive if the
OnQueryCancel event does not fire within a minute or two?
Not exactly sure what that might be, other than causing my Windows
Service, which has loaded and run the DTS, to exit/stop. Maybe there is
some trick to shut down package execution more abortively?
Best regards - Lee Gillie |