(SQL Server 2000, SP3a)

Hello all!

I've been wrestling with a bear of a problem with my DTS Package. It has a sub-package
(several of them, actually), and when I run the package in the DTS "designer" (from
Enterprise Manager) or DTSRUN.exe, everything works splendidly!

I have since made a VBScript "driver" program that is using the COM interface to DTS, and
when I execute the package, it fails with the following error:

Execution was canceled by user.

This error occurs just before calling the sub-package (which is invoked with the "Execute
Package Task"), but the previous two tasks (Dynamic Properties and ActiveX Tasks) are
successful before that Execute Package Task fails with the above error.

I've been pulling my hair out all day trying to figure out what's causing this.

If anyone can help shed some light on this issue, I'd be *hugely* obliged! Thanks in
advance!

John Peterson

Set all your tasks to execute on the main thread.

Are you using Events ?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"John Peterson" <j0hnp (AT) comcast (DOT) net> wrote

Hey Allan!

Yeah...all my tasks were executing on the Main thread. I'm not sure what you mean by
"using Events"?

I did stumble across this issue:

http://support.microsoft.com/default...b;EN-US;319058



But I don't know how to handle events in VBScript. My guess is that I can't. :-(



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Well...I got to the heart of my problem, and it can be best explained by this MS KB
article:

http://support.microsoft.com/default...b;EN-US;319058

I had someone help me write a quick-n-dirty .NET C# wrapper for the DTS package, and when
we put in the event handler for OnQueryCancel, sure enough, this bug reared its ugly head.
:-(

It's unfortunate, because I had some measure of work invested in my VBScript application,
but because I can't write an event handler in VBScript, I cannot rectify this situation in
that environment.


"John Peterson" <j0hnp (AT) comcast (DOT) net> wrote