Content

• Video Tutorial
• Step-By-Step
• Properties
• Settings UI
• Input Column Properties
• FAQ
• References
• See also

Video Tutorial

1. Download and Install SSIS ZappySys PowerPack.
2. Firstly, You need to Download and Install PostgreSQl Server from here.
3. For this sample exercise we will need new PostgreSQL table. Yo can use a query or create it on the pgAdmin server.
   Note: Make sure to connect the server.

   DROP TABLE IF EXISTS tbl_pg_Orders;
   CREATE TABLE public."tbl_pg_Orders"
   (
       "OrderID" character varying(50) COLLATE pg_catalog."default" NOT NULL,
       "CustomerID" character varying(50) COLLATE pg_catalog."default",
       "OrderDate" date,
       "OrderAmount" numeric,
       CONSTRAINT "tbl_pg_Orders_pkey" PRIMARY KEY ("OrderID")
   );
   					

   
4. Once you have created the table, you may proceed to create new SSIS package. In BIDS/SSDT create new SSIS package.
5. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
   
6. Double click on the Data Flow task to see Data Flow designer surface.
7. Here, In Visual Studio, drag and drop the DummyData Source and ZS PostgreSQL Destination in the design surface and join the components with the blue arrow.
   
8. Here, you can use OLE DB Data Source, MongoDB Source, and CSV File Source.
9. But, we are going through ZS DummyData Source for practice it and we need PostgreSQL Connection for PostgreSQL Destination.

How to create PostgreSQL Connection.

1. Right Click in Connection Manager Panel and select [New Connection...] menu item. Pick ZS-POSTGRESQL connection type.
   
2. Select ZS-POSTGRESQL Connection Manager from the Connection Managers list and Click on Add Button.
   
3. On New Connection Dialogbox enter connection attributes to connect to PostgreSQL instance and Click Test connection to verify credentials.
   
   
   
4. Click OK to save connection configure setting UI.

How to load data from source to PostgreSQL Destination.

1. The Dummy Data Source is a ZappySys Task in the Data Flow that can be used to generate testing data.
2. Double click DummyData Source to configure it.
3. From Template pick Orders and enter row count=100.
   
4. Click OK to save DummyData source configure setting UI.
5. Now on double click PostgreSQL Destination to configure it.
6. Lets configure PostgreSQL Destination, In the Connection Manager tab, select PostgreSQL Connection we have created before.
   
7. In the Component Properties, set destination Table from TableName dropdown list.
   
8. Click on Mappings tab and verify mapping. If target table is new table and its empty then all input columns will be automatically mapped as shown below. If table is existing table with some data then you can manually pick mapping columns by dragging it from source list to target list.
   
9. Click OK to save settings.
10. Execute the package and verify target data in the pgAdmin to view data.
    

Properties

• About PostgreSQL

• SSIS PostgreSQL Source Adapter
• SSIS PostgreSQL ExecuteSql Task
• SSIS MongoDB Destination Adapter
• SSIS MongoDB Connection Manager

• PostgreSQL Homepage