I have 50 DTS on a server. Is there a way to find what are
all the DTS that are currently running. Does SQL server
store these information in any system tables.

Tnx,
Aravind

No it does not.

How have you fired them off ?

The way I do it is to enter a record in a control table when the package
starts along with the package name and person who fired it. When the
package finishes I enter a stop time for that package. I then know which
ones are running and by whom

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Aravind" <anonymous (AT) discussions (DOT) microsoft.com> wrote