dotConnect for MySQL Documentation
Creating MySQL Connection

To create a connection to MySQL, do the following:

  1. Right-click in the Connection Managers pane and select New Connection from the context menu. The Add SSIS Connection Manager dialog box is displayed:

  2. In the Connection manager type list select DevartMySql and click Add. The General tab of the MySql Connection Manager Editor dialog box is displayed:

  3. Specify the server and port to connect to, your MySQL user name and password. If necessary, additionally specify the database to connect to.