Post reply

Do we have a table to query out which DTS package used a specific stored procedure?

  • March 2, 2006 at 2:28 pm

    #76496

    Do we have a table to query out which DTS package used a specific stored procedure?

    Thanks.

  • March 3, 2006 at 8:48 am

    #624637

    There's no system table or view that stores that information.  I think the best you can do is to save your DTS packages as files and search them.  I have seen a thread in this forum where someone posted a script to save all packages, though I haven't tried it.  http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181665

    Greg

     

    Greg

  • March 3, 2006 at 9:37 am

    #624652

    I've had to conduct similar documentation exercises myself... I have written a .net utility that will document all selected packages from a server and export a documented version of the packages to HTML or Text, allowing you to search, print, save into VSS for versioning..etc.

    If you think this will get you what you need, feel free to drop me a note in a private message with an email address, and I'll happily send you out a trial version of this utility.

    -Mike Gercevich

  • March 3, 2006 at 10:21 am

    #624672

    This is great.  Thanks a lot.

Viewing 4 posts - 1 through 3 (of 3 total)

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