I have a package launched trougth a my program. Sometimes, due to connection
problem with a remote sql server, it hang on a query.
I want from a my application to stop the package.
I did not get error or any exception from the package, nor the OnCancelQuery
is called.
The only way I see to stop excecution is to start the package in a thread
and then if locked call the TerminateThread, but this solution don't like me
for a lot of connected problems.

Any help?

Thanks.

Sam -

This OnCancelQuery solution has been problematic for me as well. Fine if
things are running along normally, but having this as the only safe
recourse when you are trying to shut it down due to the fact you have
detected a lock condition (unreasonably long execution time), and you
never receive an OnCancelQuery, coupled with the fact that SQL
documentation seems to suggest that anything more abortive than
OnCancelQuery could lead to database corruption, leaves you in that same
old "close-your-eyes-and-press-the-button-and-pray-for-the-best" mode again.

(grumble) As far as I know the only thing you could do is documented as
being risky. There is no guaranteed clean way of dealing with this that
I have been able to find after studying the issue for many hours. If you
find a way, I would sure be interested in knowing.

- Best regards - Lee Gillie

Sam wrote:

"Lee Gillie" <Lee (AT) nospam (DOT) odp.com> wrote

In my case, I have no problem of data corruption because the step that may
hang the package is the first and is only a copy of data from a remote
database (300 km), if it fail I clean the table and then restart the
package. I can't detect the cause of problem, because till now it have
hanged only the night.

Thanks