Re: DTS Disconected edits

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

.