SSIS connection manager to a MySQL database

• mike gman

  SSC Enthusiast

  Points: 172

  More actions

  April 26, 2019 at 7:44 pm

  #3542036

  Hello,

  Looking for some help with creating an SSIS connection manager to a MySQL database.  I have tried the following with no luck:

  https://smallbusiness.chron.com/connect-mysql-ssis-60851.html

  The error message is:

  Test connection failed because of an error in initializing provider. Authentication to host '' for user '' using method 'caching_sha2_password' failed with message: Access denied for user using password: NO

  My setup is:

  Windows 10x64

  Microsoft Visual Studio Enterprise 2017

  VisualStudio.15.Release/15.9.11+28307.586

  MySQL for Visual Studio   1.2.8

  SQL Server Data Tools   15.1.61903.01040

  Microsoft SQL Server Integration Services Designer

  Version 15.0.1100.123

  MySQL connector/Net 8.0.16

  MySQL Community Server 8.0.16

  Thanks

  Mike

• danielcai

  Newbie

  Points: 1

  More actions

  April 26, 2019 at 8:09 pm

  #3542135

  You could try out our Premium ADO.NET component to connect to your MySQL database. It is a commercial software, but we offer free developer license which you can use interactively within Visual Studio (otherwise referenced as SSDT). In addition to the out-of-box db connection capabilities, we offer many advanced features. Check out the following link for more details.

  https://www.kingswaysoft.com/products/ssis-productivity-pack/help-manual/premium-data-flow-components

• Filipe

  SSC-Addicted

  Points: 499

  More actions

  May 2, 2019 at 1:02 pm

  #3627024

  I've always used the MySQL ODBC drivers to connect to MySQL from SSIS.

  Just remember that if you use a 32 bit driver you need to run a 32 bit SSIS executable.