dotConnect for PostgreSQL Documentation
In This Topic
    Creating PostgreSQL Connection
    In This Topic

    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.