February 15, 2011 at 12:17 am
I have 100+ packages running in SQL2000 server and this packages are developed by someone else. Now I want to quickly retrieve information on which packages run on a certain database and a certain table. Just wonder if the packagedata field in sysdtspackages contain these information. But I realize this field is not readable. How can I view it? If it doesn't contain information I need, how can I retrieve these information quick instead of going to check manually one by one? Please adivse me. Thanks.
February 16, 2011 at 2:39 am
Please help. Thank you very much.
February 16, 2011 at 2:46 am
A little bit of manual intervention will be required, but the search will be automated. Here's how:
1. Open the DTS package in the DTS Designer
2. Save the package as a Visual Basic file (*.vbs) - it is one of the options along with storing the package on the server, as a file (*.dts) and so on
3. Once you have done this for all the packages available, search the *.vbs files for the information you need
*.vbs files can be opened via NOTEPAD (or any other text editor), which I believe will make things a bit easier for you.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
February 16, 2011 at 1:03 pm
This script claims to be able to script out all packages in a SQL instance so they can be searched.
http://www.sqlservercentral.com/scripts/Miscellaneous/31613/
Greg
February 16, 2011 at 9:42 pm
Had a quick look at the script - it is a VB script that does pretty much the same thing - iterate through and export all available DTS packages as text files - which can then be searched for.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
February 21, 2011 at 6:41 pm
What tool should I use to run this script? Thanks.
February 21, 2011 at 9:09 pm
Supernova Hakeem (2/21/2011)
What tool should I use to run this script? Thanks.
Nothing new :-). The *.vbs files are to be created via NOTEPAD, and simply double-clicking the file should be sufficient to run them.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply