all groups > sql server dts > august 2006 >
You're in the

sql server dts

group:

DTS Disconected edits


DTS Disconected edits jaylou
8/7/2006 1:16:02 PM
sql server dts:
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,
Re: DTS Disconected edits Sue Hoegemeier
8/7/2006 2:32:01 PM
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
[quoted text, click to view]
Re: DTS Disconected edits Allan Mitchell
8/7/2006 9:28:17 PM
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



[quoted text, click to view]

Re: DTS Disconected edits jaylou
8/8/2006 10:38:02 AM
Thank you I will try one of these.

joe


[quoted text, click to view]
AddThis Social Bookmark Button