I can use LoadFromSQLServer successfully unless the target package contains
OLAP tasks, then it appears to hang this procedure.

Anyone got a workaround ?

TIA

Just a guess, but does the target machine (the one running the
LoadFromSQLServer program) have the OLAP Task installed? If not then I would
it expect it to error, although still not hang.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Jim Trowbridge" <JimTrowbridge (AT) discussions (DOT) microsoft.com> wrote

I opened an issue with Microsoft and the reply included reference to the
thread model I was using in the DTS package (the one that had the ActiveX
script executing the LoadFromSQLServer function).

When I checked, I found that this ActiveX step did NOT have "Execute on Main
Thread" checked. Checking this option fixed the problem.

Apparently this is due to the fact that Analysis Services (and preumably
OLAP tasks in a DTS package) do not use the "free threaded" model, whatever
that means really. And this causes the conflict that results in the ActiveX
script hanging.



"Darren Green" wrote: