March 2, 2006 at 2:28 pm
Do we have a table to query out which DTS package used a specific stored procedure?
Thanks.
March 3, 2006 at 8:48 am
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://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181665
Greg
Greg
March 3, 2006 at 9:37 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy