CODEWITHSUNDEEP
sqlsql-server-2000dts
gates
gates

Reputation: 65

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!

Upvotes: 1

Views: 236

Answers (2)

Code_Tech
Code_Tech

Reputation: 795

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 !

Upvotes: 1

Tobiasopdenbrouw
Tobiasopdenbrouw

Reputation: 14039

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

Upvotes: 0

Related Questions