Hi ,

I have some DTS packages to transfer data from text files on different
computers to SQL server tavles. Now I need information about these package
name, the source of the text files and output tables, I want to have table to
hole all these data. I am sure there is a way to do it. I looked
MSDB.sysTDSpackages and other related tables, but I still don't get the data
I need , any one here knows where are the DTS source and destinition
information stored?
Thanks .

Yep it is stored inside the packages.

You can use the Object Model to get the info you need.

open a package
Loop through the Connections collection (get their details + IDs)
look through the tasks and you can then use things like SourceConnectionID,
DestinationConnectionID


Allan


"Matthew Z" <MatthewZ (AT) discussions (DOT) microsoft.com> wrote