SSIS connection manager to a MySQL database

  • mike gman

    SSC Enthusiast

    Points: 172

    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

    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: 469

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply