DTS Packages

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 t
o
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 .This isnt exactly what you're looking for but...
Save a Package as a Visual Basic File. Then have some program that reads
that file and grabs the info you need.
"Matthew Z" <MatthewZ@.discussions.microsoft.com> wrote in message
news:36F6A628-4931-4A56-AAEB-EB74B70386CB@.microsoft.com...
> 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 .sqlsql