SSIS With PostgreSQL : Connect to PostgreSQL with SSIS Components

{TOC}

Connect to PostgreSQL with SSIS Components

Follow the instructions to set up ODBC Connection manager to begin use SSIS Components with PostgreSQL database. Downloading and install ODBC drivers instruction for PostgreSQL you can find there

Configuration ODBC Connection manager

1. At first to use PostgreSQL database in you SSIS solution you need to drag-and-drop "ODBC Connection manager"Source" in the data flow tab.

1. Then open component settings (double click on the icon) and press "New" button.

1. On the opened window press again "New" button.

1. Now you can see a Connection manager setting window, press "Refresh" and navigate to the dropdown near "Refresh" button.

1. Choose PostgreSQL ODBC Connection from available connections in the dropdown list. How you can create ODBC Connection read .here

1. Now you have successful create a ODBC Connection manager. Select needed connection manager from drop-down list , select "Data accesses mode: " to "Table Name", then select needed table from drop-down list below. Make sure that everything is ok, press "Priview button and check results, you will see you data on the priview window."

1. The next you need to connect your ODBC Source to the components according to your preference.

1. The final step will be configure the ODBC Destination. Drag-and-drop ODBC Destination on the data flow and open settings (double click on the icon). Now you can see ODBC Connection managers similar with ODBC Source. Select needed connetion manager and select destination table. In the "Data access mode" property select Table Name - "Row by Row"

Congratulations! You have beed successful connected you PostgreSQL database to the SSIS Components.