Copy multiple MSSQL Tables to MySql via SSIS

Question

I am new to SSIS, but what I am trying to figure out is how I can copy my db tables from within MSSQL to MySQL using an SSIS package.

I am using the following software versions:

• MSSQL 2019
• SSDT 2022
• MySQL 6
• mysql-connector-net-8.0.31
• mysql-connector-odbc-9.1.0-winx64

I've found a couple of forums online where the process has been explained in other way around. Unfortunately I am unable to establish a connection between MySql and MSSQL server. I followed below steps;.

1. Add a Data Flow Task (DTF) to the SSIS package.
2. In Data Flow Task and add OLE DB Destination using SQL Server connection
   1. Note: I couldnt find an appropriate provider from the dropdown menu in the "Connection Manager" dialog
3. Add ODBC Source using MySQL connection.
   1. I couldnt find an appropriate provider from the dropdown menu in the "Connection Manager" dialog.

Any guidance would be greatly appreciated!

Answer 1

Hi @ADey,

If you want to load data from MSSQL to MySQL, you may need to use OLE DB Source to connect to MSSQL and then load to MySQL destination.

Use this provider to create the Connection Manager.

You may use ODBC destination or ADO.NET Destination to connect to MySQL.

To cofigure ODBC driver for MySQL, you may refer to How to Extract & Load Data in MySQL by using ODBC Driver in SSIS Package.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.