Hello Everyone, Will be migrating MSSQL 2000 server to another physical location, and I am wondering if anyone of you can help on how to identify presently/current running DTS packages? Is the a query syntax/script/t-sql code that can be executed that can give status results for each packages? Apparently there are alot of packages (more than 50) it would just be time-consuming if I will migrate them all. Thanks in advance. :)

How do you run DTS ? via SQL Agent? You can look into msdb database for job activities SELECT * FROM dbo.sysjobactivityBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/