An issue with SSIS ODBC way to connect MySQL database

Source: Internet
Author: User
Tags ssdt ssis

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.