SSIS ADO mysql Connector

Question

SSIS ADO mysql Connector

Sue_8827 81

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 accepted by question author

1 additional answer

Your answer

Answer 1

Monalv-MSFT 5,926

Hi @SushmaPeddi-7734 ,

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

Hope the following links will be helpful:

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?

Monalv-MSFT 5,926 Reputation points

2020-11-20T06:12:55.473+00:00

Hi @SushmaPeddi-7734 ,

May I know if you have anything to update?

Best Regards,
Mona
Sue_8827 81 Reputation points

2020-12-11T03:20:56.333+00:00

Followed mySQL documentation, did take some research and support from a friend on how SSH works.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

SSIS ADO mysql Connector

1 additional answer

Your answer