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



No comments:

Post a Comment