Follow-up: DTS question

[B]

How to use a dsn-less connection from DTS?
Source: MySQL
Destination: SQL Server 7.0

I have the ADODB.connection code but unsure where and how to use it.

Pls advise.

TIA!
Bob

[Simon Hayes]

"B" <no_spam@no_spam.com> wrote in message
news:41**********************@news.rcn.com...

How to use a dsn-less connection from DTS?
Source: MySQL
Destination: SQL Server 7.0

I have the ADODB.connection code but unsure where and how to use it.

Pls advise.

TIA!
Bob

You could create a Connection using the MySQL OLE DB provider or ODBC driver
(select the "Other Connection" connection type to choose from all installed
providers/drivers), then set the properties dynamically at runtime with a
Dynamic Properties task.

Alternatively, you can use an ActiveX task to create the same connection
programmatically, but using the first method is probably easier.

Simon