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.
Who is Participating?
YveauConnect With a Mentor Commented:
Try using the ODBC drivers for MySQL:

When you manage to setup a DSN using that ODBC driver, than from SSIS, make a connection to a regular ODBC datasource ... and you'll be in business.

Hope this helps ...
Marcel HopmanCommented:
You can use a DataReader Source and connect a ODBC source to it
assystAuthor Commented:

DataReader source is the adapter used to connect to an ADO.Net source, so can that be used for MySQL
Marcel HopmanConnect With a Mentor Commented:
No you can also connect a ODBC data connection to a DataReader Source
assystAuthor Commented:
Thanks to both of you. I managed to get it working.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.