I'm creating an application that runs a DTS package with an "Analysis
Services Processing Task" in the package. When I run the package in the main
thread, it runs fine. However when I try to run the package via a separate
thread (preferred so the application isn't "frozen") it won't even load. It
is definitely due to the OLAP task, for if I remove that task from the
package, it runs fine in a multi-threaded environment. I have done
exhaustive searching on the web, etc... and no luck. I've seen a few posts
about "execute in main thread", and I have set that property as well, with no
luck (the package won't even load, to be able to re-set it before executing).

I'd appreciate any feedback you can give.

Thanks,
John

In message <AB01A06A-29AE-4585-A32F-52D3D65F1C72 (AT) microsoft (DOT) com>,
jgharper <jgharper (AT) discussions (DOT) microsoft.com> writes
The OLAP Processing task is written in VB6, which has no support for
this fancy thread stuff. I don't understand it fully, but a simple
example is the OLAP task must be set to execute on the main package
thread else it throws up. Sounds like you program is introducing a
thread issue which it cannot handle.

DTS Package Fails with Dynamic Properties Task and OLAP Processing Task
(http://support.microsoft.com/default...b;en-us;282966)


INF: Analysis Services Processing Task May Not Execute Correctly
(http://support.microsoft.com/default...b;en-us;296533)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org