Hi All,

I am still using SQL Server 2000. My DTS package runs fine but after last
step dtsrun.exe process doesn't ends/hangs.
We just moved to new domain so all the servers are same but we are in new
network. Same package runs fine in development server, but in test server DTS
hangs.
I checked "Execute on main package thread" is checked.
This package process cubes there are 8 cubes. I tried to run one cube at a
time and after first cube process dtsrun process comes back fine but as i
keep added cubes... the time it takes to end dtsrun process after completing
last cube increases.. if I run full package with all 8 cubes I am not sure
when it will come back but I kill the dtsrun.exe after 20 min.
After completing all the tasks when I am waiting for dtsrun to finish/stop I
see in windows talk manager lot on activity in memory....

This package start with dynamic properties then runs cube and after each
cube process it sends email. Also when it start and end it's update log
tables.... every thing runs fine only dtsrun.exe is hanging....

Please help - Ashok

Still don't know what was the problem but managed to move by recreating DTS
pacakge. After recreating DTS package it works fine now.

-Ashok

"Ashok" wrote: