whats the best way to identify whether dts is currently running or
not?(ms-sql 2000)

Cheers
DF

Hello dishan (AT) gmail (DOT) com,

There is ideal way to do this, as DTS is just like a client application.
How dio you detect if a user is connected to yoru SQL server? Look in sysproesses
for a start. If you run the packages from SQL AGent jobs, then you can check
to see if the job is running.