all groups > sql server dts > december 2004 >
You're in the

sql server dts

group:

How to obtain "data source" from within ActiveX/VB?


How to obtain "data source" from within ActiveX/VB? Snake
12/17/2004 1:37:02 PM
sql server dts:
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,
Re: How to obtain "data source" from within ActiveX/VB? Allan Mitchell
12/18/2004 10:46:00 AM
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


[quoted text, click to view]

AddThis Social Bookmark Button