dotConnect for PostgreSQL Documentation
Creating PostgreSQL Connection

To create a connection to PostgreSQL, 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 DevartPostgreSql and click Add. The General tab of the PostgreSql Connection Manager Editor dialog box is displayed:

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