Have you ever worked as DBA? Then you would know how hard it is to keep track of all DTS packages and ongoing changes. Especially if you inherited the database from some-body else. DTS Documenter is a one simple yet powerfull tool to make your life a bit easier. It is easy to use and it will generate DTS documentation for you in a matter of seconds. You can analyse existing packages and research inconsistancies or redundancies in the existing DTS solutions.
Select SQL Server
Select DTS Package
Specify Output Folder
Porvide DTS options
You will need to have SQL Server 2000 installed either localy or available in the domain.
If you run it from workstation without SQL Server installed, you will need at least
install the SQL Server Tools, which will install the DTS access components to the workstation.
The SQL Server service pack 2 is required for the DTS documenter, and the latest service pack is recommended.
Latest SQL Server service pack can be found here:
DTS Documenter is a .Net application and and you will need to have the .Net framework 1.1 installed before you can use it.