How to Load Data From SQL Server to MySQL in SSIS Package Step by Step - SSIS Tutorial 2021.

In this video you are going to learn how you will be loading data to MySQL table from SQL Server in SSIS Package. Video shows how to download and Install ODBC drive for SSIS Package to Load data to MySQL, how to setup user permission on MySQL so you can use that user in SSIS Package to write to MySQL and How to configure ODBC Connection Manager for MySQL.


1) Download ODBC Drive for MySQL that we will use in ODBC Connection Manager in SSIS Package https://dev.mysql.com/downloads/connector/odbc/

2) In case you find error when installing above for Redistribution x86 https://support.microsoft.com/en-us/topic/the-latest-supported-visual-c-downloads-2647da03-1eea-4433-9aff-95f26a218cc0


3) Sample Connection String for ODBC Connection Manager in SSIS Package

DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=tb;UID=tb;Password=dba123

4 )Expressions for ODBC Connection Manager in SSIS Package. Make sure you have created two variables UserName and Password to use in connection String.

"DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=tb;UID="+ @[User::UserName] +";Password="+ @[User::Password]


How to load data from SQL Server Table to MySQL Table in SSIS Package



5 comments:

  1. Do you need Personal Finance?
    Business Cash Finance?
    Unsecured Finance
    Fast and Simple Finance?
    Quick Application Process?
    Finance. Services Rendered include,
    *Debt Consolidation Finance
    *Business Finance Services
    *Personal Finance services Help
    contact us today and get the best lending service
    personal cash business cash just email us below
    Contact Us: financialserviceoffer876@gmail.com
    call or add us on what's app +918929509036

    ReplyDelete
  2. We believe that every man buying a bride should be allowed to pursue happiness in the form of a successful relationship. The archaic way of building relationships - traditional meeting and meeting with someone - we consider outdated. While the traditional method is still valuable, it is no longer the only one.

    ReplyDelete

  3. Hello

    I tried to connect the MySQL database to SSIS by following your steps but I got the below error in both the drivers. can you please help me?
    Using Unicode Driver
    =========================================
    TITLE: Microsoft Visual Studio
    ------------------------------

    There was an error displaying the preview.

    ------------------------------
    ADDITIONAL INFORMATION:

    ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.5.5-10.4.17-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"student"' at line 1 (myodbc8w.dll)
    -----------------------------------------------------------------------------------------------------------------------


    Using ANSI Driver
    ===============================

    TITLE: Microsoft Visual Studio
    ------------------------------

    Exception from HRESULT: 0xC0014020
    Error at Data Flow Task [ODBC Destination [1]]: SQLSTATE: 42S22, Message: [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.4.17-MariaDB]Unknown column 'fir??' in 'field list';

    ------------------------------

    ReplyDelete
  4. I will go to my goal, get good grades, and I can turn to services for writing papers such as this site https://essaysrescue.com/essaypro-review/ for help, they will do everything competently and quickly, and most importantly, with high quality.

    ReplyDelete
  5. As for the driver to connect to db, I found salesforce ODBC driver

    ReplyDelete