An issue with SSIS ODBC way to connect MySQL database

Development tools VS2010 SSDT

In recent projects, it is necessary to integrate the MS SQL Server database with the MySQL database for data interaction, and the installation of the MySQL ODBC Connector plugin during the development of the SSIS package is quite time consuming. I have downloaded the version 5.3.4 Mysqlconnector. OS System is win8,1 64-bit, so the corresponding 64-bit plug-in is installed.

When you find the Administrative tools in Control Panel and then set up the ODBC source, everything is OK Test connection successful. Settings complete when you create a new MySQL database connection in the SSIS package, you find that the plug-in does not match the application structure. With the help of search engine query after roughly judge is need to install 32-bit plug-in. A little touch the mind, is clearly 64-bit system why the 64-bit plug-in does not work, to install 32-bit. Google for a long time to understand the original reason for the development of tools, VS2010 only 32-bit version, the corresponding SSDT nature is also 32-bit. Even if the upgrade to the VS2012,SSDT is actually also the 10 version of the SHELL,32 bit.

Fill in a few pictures later.

Hopefully this experience will help with the initial configuration of the package that uses ODBC to develop SSIS packages.

An issue with SSIS ODBC way to connect MySQL database