How to Load CSV File to MySQL Table in SSIS Package Step by Step -SSIS Tutorial 2021

How to Load CSV File to MySQL Table in SSIS Package Step by Step - How to Load Text File to MySQL Table in SSIS Package. In this video, you will learn

  1. How to download and Install ODBC Drive for ODBC connection manager for MySQL in SSIS Package.
  2. How to create UserName andPassword Parameters to use in MySQL Connection Manager in SSIS Package.
  3. How to create and provide permission to MySQL User for Loading data from CSV or Text File to MySQL Table.
  4. Create SSIS Package step by step to load data from CSV File to MySQL Table.

--Connection String for ODBC Connection Manager
DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=techbrothersit;UID=tb;Password=dba123


--Download Links
https://dev.mysql.com/downloads/connector/odbc/

https://support.microsoft.com/en-us/topic/the-latest-supported-visual-c-downloads-2647da03-1eea-4433-9aff-95f26a218cc0


Expression for Connection Manager

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

How to Load data from text file to MySQL table in SSIS Package




No comments:

Post a Comment