sql server dts: DTS packages-input and uotput file location -- sql server dts

DTS packages-input and uotput file location

Matthew Z
8/19/2005 10:01:04 AM

sql server dts: 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?

Re: DTS packages-input and uotput file location

Allan Mitchell
8/19/2005 11:20:06 PM

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

[quoted text, click to view]