How to get a list of DTS packages that are running

• karami

  SSC Journeyman

  Points: 92

  More actions

  August 5, 2003 at 7:40 am

  #106313

  I want to get a list of DTS packages that are running on an SQL Server. Can anyone help?

• dm

  Ten Centuries

  Points: 1105

  More actions

  August 5, 2003 at 8:08 am

  #468662

  Would these be packages that are running as part of a job or packages that someone is currently running manually?

  Diane

• karami

  SSC Journeyman

  Points: 92

  More actions

  August 5, 2003 at 8:44 am

  #468675

  Diane,

  I can't say antyhing about how these packages will be called. The possibilities are :

  1. packages that are run manually within Enterprise Manager

  2. packages that are part of jobs

  3. xp_cmdshell 'dtsrun ...' commands from an external application

  Regards