Connecting to MySQL from SSIS, SQL Server Integration Services does not have its own component to connect to the mysql source by default, and we need to install it ourselves.
Both ways: both using ODBC and ADO.NET drivers can connect to the mysql database and both work fine.
Because it is relatively simple to connect to MySQL data sources using ADO.NET, this article uses the ADO.NET method.
First, download the mysql .net connection driver, download the address:Tourists, if you want to see the hidden content of this post, please Reply
Once the download is complete, install it, then reopen the SSIS project with VS 2019 and right-click "New ADO.NET Connection", as shown below:
Select the MySQL Data Provider driver, as shown in the following figure:
Fill in the mysql configuration, the main settings:server、user id、port、persistsecurityinfo、database、passwordThese parameters are sufficient.
The Persist Security Info attribute means whether to save security information, which can be simply understood as "whether ADO saves password information after a successful database connection".
True means to save, False means not to save
We need to set it uppersistsecurityinfo is true。 Click Test Connection, as shown below:
The value after the parameter talk is:
Try adding the ADO NET source, database access settings SQL command, fill in the following script:
Click Preview to find that you can successfully query MySQL data, as shown in the following figure:
Resources:
Tourists, if you want to see the hidden content of this post, please Reply
(End)
| 
Posted on 8/1/2020 9:16:09 PM
|
|
|
|
Posted on 10/2/2020 6:45:11 PM
|
Landlord|
Posted on 7/20/2021 3:49:29 PM
|
Just used, thank you for sharing