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

Cheers
DF

Hello dishan@gmail.com,

[quoted text, click to view]

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