I have an activex object in a DTS package which contains hard-coded info that
really should be dynamic. There is an OLE DB Property called "Data Source"
from the UDL file that appears to contain the value I want. Is there a way
to obtain that value? ( I am new to DTs and do not know the right names for
things yet.) The activex control moves files around using hard-coded
machine\path\files names. Data Source appears to be the same as the machine
name above, so if I could query the value of the Data Source the code could
be moved more easily between machines. A little code example, or a link to
such a sample, would be very much appreciated.

Thanks,
Michael

Does this help

Connections
(http://www.sqldts.com/default.aspx?101)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote