sql server dts: I have to analyze all DTS packages of a few servers.
Is it possible to document the packages with the workflow and
properties, in any relatively quick method?

Right now I am opening the packages and documenting each step
manually.

I have a few very huge packages that are used to build a warehouse.

Consider saving the package as a Visual Basic file. This "documents" all the
relationships in code. It's probably not exactly what you want, but it's
really easy.

If you want your own format you might write a script using the DTS object
model to loop through all the steps and print out the precedences and
properties (this is how the save as VB works).

--
Bill Hodghead
Technical Test Lead
Enterprise Management Division
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]