Is there a way I can document what is in a DTS package?
Ideally I would like to generate a script which lists the
tasks, connections, transformations, etc. It seems quite
laborious and prone to error to do this by hand.

Thanks for any suggestions.

Save it as BAS ?

hth - Lee

"dschrier" <dschrier13 (AT) hotmail (DOT) com> wrote

There used to be a really cool tool by a company called Mosaic something.
They do not appear to be around anymore so the way I would document this is
to script to VB and save it in Sourcesafe. Either that or if you know what
it is you want to script then you can use the Object model to script out
those things you want to know about yourself to text file.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"dschrier" <dschrier13 (AT) hotmail (DOT) com> wrote