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

[quoted text, click to view]

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