hi, I have to take over on a 500 dts project....and I'm tryng to understand in wich way I can easily document this "monster". one idea is to use visio reverse engineer via oledb for dts (DTSPackageDSO) but, even if the data source is ok, nothing works...colud anybody help me even suggesting thirdy parts software

thanks in advanc
lavez

DTSPackageDSO is a provider that allows you to expose a package data pump as
a consumable data source from outside. It is not about exposing the package
meta-data.

There is no off the shelf product I'm afraid. Best bet would be to look at
the old ScriptPkg utility that shipped with SQL 7.0. This produced VB code
from a package. The important bit is that it will show you how to write code
that enumerates objects, and using this method you should be able to write a
documenter.

The basics is just about loading a package and enumerating any collection
you can find. The object model is documented in Books Online, so from there
you can see the main three collections are tasks, steps and connections.


--
Darren Green
http://www.sqldts.com

"lavez" <lavez (AT) msn (DOT) com> wrote

use visio reverse engineer via oledb for dts (DTSPackageDSO) but, even if
the data source is ok, nothing works...colud anybody help me even suggesting
thirdy parts software?

thank you very much, Darren; I will try in this way; the thing that "sound" very strange to me is that appereantly nobody else have this kind of problem..


----- Darren Green wrote: ----

DTSPackageDSO is a provider that allows you to expose a package data pump a
a consumable data source from outside. It is not about exposing the packag
meta-data

There is no off the shelf product I'm afraid. Best bet would be to look a
the old ScriptPkg utility that shipped with SQL 7.0. This produced VB cod
from a package. The important bit is that it will show you how to write cod
that enumerates objects, and using this method you should be able to write
documenter

The basics is just about loading a package and enumerating any collectio
you can find. The object model is documented in Books Online, so from ther
you can see the main three collections are tasks, steps and connections


--
Darren Gree
http://www.sqldts.co

"lavez" <lavez (AT) msn (DOT) com> wrote in messag
news84FABE4-30DF-40D5-B406-2ED00DB05EA2 (AT) microsoft (DOT) com..
use visio reverse engineer via oledb for dts (DTSPackageDSO) but, even i
the data source is ok, nothing works...colud anybody help me even suggestin
thirdy parts software

It has been asked several times before, but nobody has ever produced
anything publicly available. There was a product that produced an XML
representation, which could then be used with XSL to document a package, as
suggested in their own description, but that company is no more.

--
Darren Green
http://www.sqldts.com

"lavez" <lavez (AT) msn (DOT) com> wrote

problem...