I tried posting this earlier but am still stuck:

I'm running SQL7.0sp4 on NT4.

My Package consists of one task, an ActiveX script that simply
attempts to create an object (an ActiveX written in VB6).

The script runs fine if I right-click on the package and select
Execute.

If I try to execute it in any other way it hangs on the createobject
command (I have a debug line written to an FSO text file immediately
before that line and another after it, only the first gets written).

Now I understand that scheduling the package to run makes it execute
under the user for which the SQLServerAgent is set up for(so hanging
there is almost certainly permissions, registry set up etc for that
user), but why does it also hang if I bring up a command prompt and
execute the package using DTSRun? Surely DTSRun is running as the
user I'm logged in as?

Help, anyone?

Thanks

Dik

Have you tried setting the ActiveX Script Task to execute on the main
package thread?


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

"fixitdik" <nojunk_fixitdik (AT) hotmail (DOT) com> wrote

Sorry Darren, you must think I am so dim as I did say I would try
that, but the reason I hadn't (and therefore re-posed the question)
was because I couldn't find the option. However, as with the opening
of .DTS files, a little perseverance and I found it (along with
looking deeper at some of your previous responses to other similar
questions) and sure enough, when I found it and set it, we were up and
running.

Thank you once more, I hope one day I can return the favour in some
other news group, mean time keep up the outstanding work :0)

Dik

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

Not a problem. Just ask if you can't find the option, I just get lazy
sometimes and go for the short answer.


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


"fixitdik" <nojunk_fixitdik (AT) hotmail (DOT) com> wrote