Hello together,

does anybody knows, if there is a way (maybe a toll) to document which
tables (or also views, stored procedures etc.) are used in a DTS
Package?

Thx and greetz from germany

Dietmar

Hello hoffmadi,


I do not know of a tool that will specifically list the tables and procs
used as you could be using complex statements in your package and the tool
would have to parse the tatement.

You have a number of tool available though

1. write your own against the object model

2. Have a look here for the first three tools

Products
(http://www.sqldts.com/default.aspx?401)

also look at the DTSCompare tool by red-gate




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

Hello Allan,

thx a lot for your help!

the tool dtsdoc is great and helps me a lot!

You must know: i am the projectmanager to migrate oaur "old" DWH to a
Datamart Design and this helps a lot to documentate all the dts
Packages.

Greetz from germany

dietmar