Hi all,
I have a main DTS Package (SQL Server 2000) that executes another DTS
Package (with Analysis Services Processing Task) with Execute Package Task.
When I execute the main package (click in the green arrow inside design
package window) it hangs up when executing the Execute Package Task.
I have other Execute Package Tasks inside this main DTS that run ok.
If I try to execute that step separated (right clik, execute step), it runs
ok ...
It's very strange... I have service pack 4 in the machine that executes
Enterprise Manager.
Does anybody have already see this problem???

Thank you very much

Alexandre Calderaro
MSCDBA

Alex wrote:
Set the Exec Pkg Task to execute on the main thread, see workflow
properties. Probably something in the child that is not thread safe.

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