Hi there,
how do I get hold of a DTS Connection from within an ActiveX
Script Task. I don't want to have to create another connection and hard
code the logon details.
I'm sure this must be possible, but cannot find anything in the online help.

If you want to use DTS connection with ADO - it is not possible.

"Waldy" <waldy (AT) 69 (DOT) cock> wrote

You can find numerous examples of accessing connections here

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

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Waldy" <waldy (AT) 69 (DOT) cock> wrote

In article <uEs061QqDHA.3844 (AT) tk2msftngp13 (DOT) phx.gbl>, Waldy
<waldy (AT) 69 (DOT) cock> writes
In addition to the other posts.

You can build an ADO connection string by reading the properties off the
DTS connection, all apart from the Password for SQL security.

You may be better off using the Execute SQL Task, or even the DataPump
task. The DataPump task doesn't have to transfer data, you can just use
it to read data, and then combine that with a lookup for example and
work with the input all in the transform ActiveX script.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org