Thanks for replying
I need a diagram of processes + entities involved. We have around 80 DTSs and I would like to see what they do without having to open and inspect each one

There used to be one that described the package in XML from Mosaic
Interactive but they have disappeared. There is no documenter built in.
What kind of documentation do you need.?



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Is there then a way to enumerate obj/task/... automatically and write it somewhere

----- Allan Mitchell wrote: ----

Then I think your only way is to go through the object model for eac
package. You can enumerate all the objects/tasks/connections/dependencie
and write it to whatever format you require

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP
www.allisonmitchell.com - Expert SQL Server Consultancy
www.SQLDTS.com - The site for all your DTS needs
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or


"MarielC" <anonymous@discussions.microsoft.com> wrote in messag
news:937B7102-FB2B-4E28-A9F5-AD6F2A9100B5@microsoft.com..
[quoted text, click to view]
and I would like to see what they do without having to open and inspect eac
one

Then I think your only way is to go through the object model for each
package. You can enumerate all the objects/tasks/connections/dependencies
and write it to whatever format you require.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
and I would like to see what they do without having to open and inspect each
one.
[quoted text, click to view]

In message <62C9CF00-0B36-4284-97A5-B5D7C5BBBA9B@microsoft.com>, MarielC
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

You can do some simple code such as -

Dim pkg As DTS.Package = ...Load Package...

For Each conn as Connection In oPkg.Connections
.. Read conn properties here and write...
Next

There are three main collections, connections, steps and tasks. The
detail for each task is contained in the custom task.

For the full object model try Books Online -
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books
\dtsprog.chm::/dtspapps_64z0.htm)

A good start point would be the ScriptPkg sample that shipped with SQL
7.0.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org