Post reply

sp_depends for DTS packages?

  • December 20, 2001 at 3:48 am

    #104708

    Is there a way of doing the equivalent of an sp_depends for DTS packages? I am trying to track down orphaned, unused DTS packages in our servers, and need a way to cross-reference if a DTS package is called elsewhere. Where is all the DTS package information stored internally in SQL Server?

    Thanks

    Jay

    p.s. using SQL7/OLAP (SP3)

  • December 20, 2001 at 4:56 am

    #421331

    There are some tables in msdb. Dont know that you'll find a way to do this reliably - I often have packages sitting on the server that are only run manually, or are called/modified by a VB app sitting elsewhere.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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