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

You can find downloading, installing, and installconfiguring ODBC drivers instructioninstructions for PostgreSQL you can find therehere

ConfigurationConfigure ODBC Connection manager

1.At first to

1. To use PostgreSQL database in you SSIS solution you need to drag-and-drop "ODBC Source" ininto the data flow tab
   of your SSDT:

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

3.On3.If the openedconnection windowmanager is configured for the first time, on the Configure ODBC Connection Manager window, press againthe "New" button.button again.

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

5.Choose PostgreSQL ODBC Connection from available connections in the dropdowndrop-down list. HowInstructions on how you can create ODBC Connection read .here

6.Now6.Congratulations, you havehalve successfulsuccessfully createcreated athe ODBC Connection manager. Select neededa required connection manager from drop-down listlist, ,and then select "Data accesses mode: " to "Table Name", then select needed table from drop-down list below. Make sure that everything is ok,ok pressby "Priviewopening "Preview Query Results" with "Preview" button and check results,results. youYou will see you data onin the priviewPreview window."window.

7.The next you would need to connect your ODBC Source towith the transformation components according to your preference. preference:

8.The final step willwould be to configure the ODBC Destination. Drag-and-drop ODBC Destination ononto the data flow and open settings (double click on the icon). Now you can see ODBC Connection managers similar with ODBC Source. Select neededthe connetionrequired connection manager and select a destination table.

In the "Data access mode" property select Table"Table Name - "RowRow by Row"

Congratulations! You have beedbeen successful connectedin youconnecting your PostgreSQL databasedatabases towith the SSIS Components.SSIS!