assyst
asked on
MySQL 4.1 Migration to SQL Server 2005 using SSIS
How do I migrate from MySQL 4.1 to SQL Server 2005 using SSIS. I am not able to find a suitable provider which can be used with MySQL 4.1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use a DataReader Source and connect a ODBC source to it
ASKER
mahopman,
DataReader source is the adapter used to connect to an ADO.Net source, so can that be used for MySQL
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to both of you. I managed to get it working.