Post reply

How to get the DTS Package name from spid?

  • December 1, 2004 at 3:15 am

    #109111

    Hi,

    we used to run sp_who2 to get the active process.

    we come to know form the Program Name field a DTS Package is executing.

    By using DBCC Inputbuffer(spid) we get only the sqlstatement of the DTS Package.

    we want to know the Name of the DTS Package which contains this sql statement.

     

    Hoping that everyone got the scene Please help with it.

     

     

  • December 1, 2004 at 5:20 am

    #532032

    Something we do is have a tracking table that every DTS package writes to that contains their start/end and SPID for cross reference purposes.  We also use that table for "traffic cop" issues.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

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

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