Detect when a package is running

• majnoon

  Valued Member

  Points: 71

  More actions

  September 19, 2003 at 2:48 am

  #83175

  Hi:

  Is there a way to detect if a dts package is already running, and when complete using sql or any other script

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 21, 2003 at 5:32 pm

  #475180

  If you are using SQL 2000 and have Package Logging enabled. You can check the Execution status in sysdtspackagelog.

  An executing package will have a start time, but no end time. Also, if you want to dig further and determine which step is executing, check sysdtssteplog.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface