dtsdoc features

These are the main features of dtsdoc:

Wizard based interface (only 3 steps)
Extensive DTS package info extraction
Support for file based packages and packages hosted on SQL Server instances
Document step precedence constraints
DTS packages call tree image
XML output
XSL parser
XSL templates included to generate HTML files
Syntax highlighting (SQL, VBScript and JScript)
Command line support for scheduled runs
Autodiscover SQL Server instances on the network and retrieve packages list

DTS documentation support

dtsdoc supports most of the data transformation packages tasks. We are improving dtsdoc to get more useful info and improve the way it is documented. At this moment dtsdoc allows you to document the following info:

Package general properties
Connections
Tasks

Active scrit tasks
Bulk insert tasks
Create process tasks
Data driven query tasks

Transformations
Lookups
Queries

Data pump tasks

Transformations
Lookups

Dynamic properties
Execute package tasks
FTP tasks
Message queue tasks
Transfer databases tasks
Transfer errors tasks
Transfer logins tasks
Transfer master stored procedures tasks
Transfer jobs tasks
Transfer objects tasks
Send mail tasks
Olap process and Prediction tasks

Steps

Properties
Step precedence constraints
Workflow ActiveX code

Package global variables

Data output

dtsdoc can generate database documentation in different formats using XSL templates.

Take a look at the output sample.

New version 1.2.5 available! dtsdoc 1.2.5 is ready and available for download. This new version allows you to split the documentation in various files. It builds an index file linking each package automatically. Save hours documenting your DTS packages for only $49.95

Need to document your databases too? Take a look at our other product: dbdesc. It will automatically document your SQL Server databases in various formats.

Other sections

"... It is particularly helpful to have the parameters listed so close to the SQL itself. That in of itself makes the outputted document more helpful than the actual DTS designer, which requires you to go to flip between different modal dialogs to see the SQL versus the parameter setup. And if you have to set up some tricky SQL via disconnected properties (e.g., passing both input and output parameters via a sproc), then you're in real trouble trying to sort things out in the designer! My package had one of those, and still everything just came out perfect in the HTML."

John Barone