Post reply

Detect when a package is running

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply