Tutorial :DTS packages, SQL Server 2000



Question:

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!


Solution:1

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 !


Solution:2

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
Previous
Next Post »