The DTS connection is blocked, may be?! You could verify this using sp_who2

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




"Zeng" <zzy (AT) nonospam (DOT) com> wrote

Hi,

I'm executing a DTS package and it's stuck at 95% completion. All the the
package does is copying store procs and functions from one server to another
server, with the option of deleting the targeted items first before copying.
Does anyone know how to resolve it? I have tried to kill the process and
restart but still get stucked at the same point.

Thank you very much for your help