a
installation
MySQL
of the database
ODBC
DriveDownload MySQL Connector ODBC 3.51.rar Click Setup to install by default! As shown in the ODBC data Source Manager, you see "MySQL ODBC 3.51 Driver" That means the installation was successful! Of course you can't see it, then you'll have to reinstall it! And of course there are different versions!
two
Establish
MySQL
of the
ODBC
Data SourceAs shown in the following:
Special Reminders:Be sure to set character sets in the Connect options bar, otherwise the import into SQL Server2005 will appear garbled! I tested each of the following three types: (1) Set NAMES ' GBK ' Note: GBK is the database Chinese character set.
It is equivalent to the following three-sentence instruction:
SET character_set_client = GBK;
SET character_set_results = GBK;
Set character_set_connection = GBK; (2) Set character_set_results = GBK (3) Set character_set_results = gb2312 then click the "Tset" button, If that means the connection is successful!
three
Create SSIS
Project To create a new SSIS project, in Connection Manager or data source, create a new connection, select the ADO connection, and fill in the following information:
Remind me: select here. NET Provider, select "DataReader source" in the data source in the Data Flow task, and if the data flow target chooses "OLE DB target", the data conversion component should be added to the data type conversion in the middle of the Provider. Enter the password, test the connection, if you have a "connection test success" prompt, that is done! O (∩_∩) o ... Ha ha! Four problems encountered in MySQL are still Chinese garbled, character set settings. You can view the settings for the client and server-side character sets by entering the following command in command-line mode. I am writing this article to test everything is OK! Give, for reference! Of course, due to the different version and the environment, the change can happen! Welcome to communicate with me!