April 26, 2019 at 7:44 pm
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
April 26, 2019 at 8:09 pm
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.
May 2, 2019 at 1:02 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply