Is there a table that hold all the English information for all the
connections,steps and tasks in a DTS job?

in a DTS job's GUI Disconected Edits there are connections, that have
datasorces.
there are tasks that show file locations either for importing a file or the
destination for exporting file.

Is there a way to get a full list of all the GUI connections, and file
locations?

TIA,
Joe

To do this you will either want to write your own viewer (using the object
Model) or get one already built (search for "DTS Documenter" on Google)

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"jaylou" <jaylou (AT) discussions (DOT) microsoft.com> wrote

No...there is no table to query to get that information. The
packages are just stored in binary format in msdb in the
table sysdtspackages.

-Sue

On Mon, 7 Aug 2006 13:16:02 -0700, jaylou
<jaylou (AT) discussions (DOT) microsoft.com> wrote:

Thank you I will try one of these.

joe


"Allan Mitchell" wrote: