Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  DTSRun.exe hang?!?

Author  Topic  Jay99 468 Posts Posted - 2001-08-20 : 09:04:58 /* print @@version Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1) */ I have a bunch of scheduled DTS packages. I recently added logic to many of them that figures out the name of the current server based on the Environment Variable COMPUTERNAME and stores that in a global variable. Then the packages dynamically set up the connections, log to server, and other stuff based on that global. . . . it works great . . . However, the SQL Server Agent jobs never complete even though all of the steps in the package are completed and show success. I am not running SP1 and I see there is a DTSRun fix in there regarding 'Execute on main package thread'. The bug sheet doesn't quite read like my problem . . . Any ideas? Jay Jay