Copy multiple MSSQL Tables to MySql via SSIS

ADey 0 Reputation points
2024-11-18T06:05:23.42+00:00

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,150 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,610 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 38,621 Reputation points
    2024-11-18T08:02:59.3833333+00:00

    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.

    User's image

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.