I having problems with the following scenario.

(1) When I run a DTS package that processes a cube it works fine.

(2) When however I run this package from within another package it just
hangs, i.e. starts but nothing happens.

Both packages run under the same Windows authorisation which is
DomainName/Administrator.

Server is W2k: SQL is SQL2k - however the server is not the domain
controller. DomainName/Administrator is part of Olap Administrators on the
domain controller.

Any help appreciated.

Thanks - Dave

Sorry server is NT and the same problem occurs if running the package on the
domain controller.

"Dave Williams" <david_n_williams (AT) lineone (DOT) net> wrote

Set the calling task in the parent package to execute on the main thread.

Same problem as this-

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


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

"Dave Williams" <david_n_williams (AT) lineone (DOT) net> wrote