Ssis odbc connection to the mysql database, ssismysql
System Environment: WIN 10 64-bit
1. Install the Mysql odbc ctor plug-in
Link to the article description:
Https://www.cnblogs.com/santiagoMunez/p/4780301.html
Plug-in download link:
Https://dev.mysql.com/downloads/connector/odbc/
2. configure a 32-bit ODBC Data Source
Entry: control panel system and security management tools
Double-click ODBC Data Source (32-bit)
Go to the page
Switch to the system DSN tab, scroll and select MySQL ODBC 5.3 Unicode Driver, and click Finish
Configure the Data Source and user Name and password, and select the corresponding Database (note: the Data Source Name must be named by yourself, and the Database needs to be selected by yourself)
The following are the configured data sources.
3. Open SSDT, create an ODBC data source, and select the data source you just created, as shown in. Enter the user name and password (consistent with the user name and password when setting the data source)
The subsequent steps are similar to those of other data sources.
In general, the configuration is relatively simple. I installed a 32-bit Mysql odbc ctor plug-in the first step. I have never tried this, my system is 64-bit, and it is also installed with 32-bit plug-ins. If you cannot use 64-bit plug-ins during the configuration process, change to 32-bit, it should not have any impact. The most important thing is that it can be used, right.