I have a DTS package that loops through a temp table of records and imports
a list of files based on these records.
I'm wondering if it's possible to check the state of the package from within
my ActiveX task that is doing the looping, to see if the user running the
package has it the cancel button?
I'd like to be able to stop the loop if the cancel button is clicked - the
project is still in DEV and that's why I'd like to be able to stop it if
necessary.
My original aproach was to use a ConfigSettings table I have, and add a
value in there that I can check during the loops to indicate if I should
exit the loop or not, but then thought maybe there would be a way to just
check the state of the package to see if the cancel button was pressed or
not.

Thoughts?

There is no way I can think of doing this. Clicking cancel sets a stat which
is checked on the OnCancel event which tasks can implement. They detect that
cancel has been set and then bail out. Unfortunately the script task does
not raise OnCancel during the script execution, so no I think is the answer.
You could do this with code, use a MsgBox statement and click Yes or No to
continue, nasty but it would work.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Simon Worth" <simon.worth (AT) gmail (DOT) com> wrote

Yeah, that's what I thought the case may be. I decided to just use the
config table instead, and it works.
Thanks for the response though.

Simon

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote