It seems that this has been way too hard. I've read several articles online and none of them are up-to-date. I reach a dead end not long after starting.
I found some information here on this forum, but it is not detailed enough.
http://forums.mysql.com/read.php?60,585162,585162#msg-585162
-------------------------------------------------------------
How to connect and load data from MySQL to SQL Server
-------------------------------------------------------------
1 - Download the 32 bit ODBC driver.
go to the MySQL website and download: “mysql-connector-odbc-5.2.4-ansi-win32 msi”
NOTE: Do not use the 64 bit driver on BIDS 2008. BIDS 2008 is 32 bit. You will get a mismatch error when creating SSIS’s connection manager: “The specified DSN contains an architecture mismatch between the Driver and Application”
OK I did this. It took me to a screen saying to repair or remove. So i assume I didn't need to do anything else.
Here is a link to the screen shoot:
http://i.img ur.com/p8HViIO.png
(please remove spaces so you can see the screen shots)
2 - Create a User DSN
You need to open the using windows 32 ODBC admin tool. DO NOT open the regular ODBC admin, in control panel. Open the ODBC admin located here: c:\Windows\SysWOW64\odbcad32.exe. If you use the default ODBC admin…it will not work. Additionally you must create a “User DSN” - NOT a System DSN. Otherwise it will not show up in SSIS
NOTE: the screens look the same so you will have no way of knowing whether you are in 32 BIT ODBC Admin tool or not.
I put the path above in Windows Explorer and this screen popped up:
http://i.img ur.com/TnSVGef.png
The instructions say: "Additionally you must create a “User DSN” - NOT a System DSN." but doesn't give you any idea how to do this or what to look for.
I clicked the add button and got this screen with NOTHING about MySQL. I did find something about Oracle.
http://i.img ur.com/MF69SDF.png
So at this point I have no idea what to do!!!