Creating PostgreSQL Connection
In This Topic
To create a connection to PostgreSQL,
do the following:
- Right-click in the Connection Managers pane and select New Connection
from the context menu. The Add SSIS Connection Manager dialog box is displayed:

- In the Connection manager type list select DevartPostgreSql and
click Add. The General tab of the PostgreSql Connection Manager Editor
dialog box is displayed:

-
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.