How to connect to Mysql

SLi 105 Reputation points
2024-01-23T07:06:03.7966667+00:00

How can i connect to Mysql database in SSIS package?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server Integration Services
{count} votes

Answer accepted by question author
  1. ZoeHui-MSFT 41,516 Reputation points
    2024-01-23T07:12:26.6+00:00

    Hi @SLi,

    You may use ODBC driver to connect to Mysql or the .Net Framework Data Provider for MySQL.

    You may follow this documentation step by step.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 47,576 Reputation points
    2024-01-23T07:15:32.8533333+00:00

    As you do it with any other RDBMS: Install the adata provider, OleDB or ODBC, and then use it to connect & query data. https://dev.mysql.com/downloads/

    0 comments No comments

  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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.