Tutorial :DTS packages, SQL Server 2000


I'm currently in the process of cleaning up a sql server 2000 instance. I found 10 Local Packages that were created 4-5 years ago. In an effort to clean up old processes, I want to delete these packages. My question is, how can I determine if they are still in use. Does the start and end time on the log file suffice? Thanks!


When you open SQL Analyser--> DTS--> Local packages, in right side, there is a column named STATUS. It shows whether package is active, inactive, running etc. You can identify directly from there !


You have checked whether any of the package are still part of a schedule?

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »