SSIS ADO mysql Connector

Question

Hello,

I am getting error when trying to connect to MYSQL over SSH. What am I doing incorrectly.

The same works for MYSQL workbench. I am also trying to get ODBC working but not sure how to add the SSH piece.

TITLE: Connection Manager

------------------------------

Test connection failed because of an error in initializing provider. Unable to connect to any of the specified MySQL hosts.

------------------------------

BUTTONS:

OK

------------------------------

Answer 1

Hi @SushmaPeddi-7734 ,

We can also use ODBC Data Provider to connect to MySQL from SSIS.

Hope the following links will be helpful:

1. Connecting to MySQL from SSIS
2. MySQL Connector/Net connection strings
3. Unable to connect to any of the specified MySQL hosts

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?