Friday, July 28, 2017

How to configure MySQL ODBC Drivers for SSIS?

Software required 

- MySQL ODBC connector 5.3.9 (32 bits)
- Microsoft Visual Studio 2012
- Window (64 bits)

Note: Microsoft Visual Studio 2012 support MySQL ODBC driver (32 bits) only. Hence, MySQL ODBC connector 5.3.9 (32 bits) is required on Window (64 bits).


Installation steps
  • On Window 64 bits, the installed MySQL ODBC driver (32 bits) will not show at ODBC Data Source Administrator console.
  • To configure the MySQL ODBC driver (64 bits), browse to "C:\Windows\SysWOW64" and type in the command "odbcad32" to launch ODBC Data Source Administrator console
  • Configure "User Data Sources" as usual, Microsoft Visual Studio will be able to detect the newly created "User Data Sources" that configured on 32 bits driver.