October 4, 2005 at 10:30 am
SQL 2000
I have three DTS packages, each consisting of around ten Execute SQL tasks as well as some Transform Data tasks. I know that somewhere in one of them there is a statement which contains the word UNALLOCATED. Can anyone suggest an easier way of finding the statement in question than opening each task up in Enterprise Manager and searching it manually?
--
Scott
October 4, 2005 at 11:30 am
You could save them as visual basic files and then open each one in text editor and search.
October 4, 2005 at 6:40 pm
Scott,
Send me an email to mgercevich_nospam@gmail.com (remove the _nospam from the address) and I would happily send you a copy of a utility that I wrote a while back. The utility will extract the contents of 1-multiple DTS packages into either an formatted HTML doc as well as extract all your dts packages into Text files that can be saved into Visual Source Safe. Either option will allow you to search and find any and all instances of the text string.
I originally wrote this utility to document the state of a servers DTS packages, as well as allow comparisons between development and production server environments. If you want to try it, let me know.
I plan to enhance this utility to dig deeper into all the properties of all custom tasks... Currently it extracts most of the important attributes of the built-in tasks. It also offers color coding and line numbering of the Active-X Scripts in Active-X Script Tasks as well as all workflow scripts.
Colors are customizable and some attributes of the HTML output are selectable. Let me know if you need it and I'll send you a .zip of the app.
HTH,
-Mike Gercevich
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply