all groups > sql server dts > december 2004 >
You're in the

sql server dts

group:

DTS & Cube processing


DTS & Cube processing Dave Williams
12/23/2004 1:23:39 PM
sql server dts:
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

Re: DTS & Cube processing Dave Williams
12/23/2004 1:29:42 PM
Sorry server is NT and the same problem occurs if running the package on the
domain controller.

[quoted text, click to view]

Re: DTS & Cube processing Darren Green
12/23/2004 2:03:56 PM
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.aspx?scid=kb;en-us;282966)


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

[quoted text, click to view]

AddThis Social Bookmark Button