IMPORTANT NOTE:

Please note that ZappySys no longer sells individual SSIS Bundles, Tasks, or Components. We now offer integrated data integration editions only.
You can compare editions here: Compare SSIS PowerPack Editions.

SSIS PostgreSql Integration Pack

SSIS PostgreSql Integration Pack is your complete toolset to automate PostgreSql integration scenarios in SSIS. Using simple drag and drop interface you can read data from PostgreSql or Bulk insert data into PostgreSql. You can also execute any valid PostgreSql DDL / DML commands inside SSIS (e.g. Create Table/ Drop Table/Get Count). It includes PostgreSql Source Connector, PostgreSql Destination Connector and PostgreSql ExecuteSQL Task.

Features

Bulk extract/output PostgreSql data
Support for SQL queries to extract data in bulk without installing any driver
Bulk insert data into PostgreSql Table
Intuitive user interface with examples makes PostgreSql learning super easy and fast
Support for executing DDL statements such as Create/Drop table
Execute DML statements such as Select/Insert/Update/Delete and save result to variable
Support for saving SingleValue from response such as count from query
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: PostgreSql related articles

Download Buy View All Tasks

SSIS PostgreSql Source (Query/Read/Extract)

SSIS PostgreSql Source can be used to extract large amount of data from PostgreSql. This component supports SQL like query language to query PostgreSql data without installing any drivers.

Go to top

SSIS PostgreSql Destination (Bulk Insert)

SSIS PostgreSql Destination can be used to bulk insert large amount of records to PostgreSql storage from any data source using SSIS.

Go to top

SSIS PostgreSql ExecuteSQL Task

SSIS PostgreSql ExecuteSQL Task can be used to execute ad-hoc commands for PostgreSql (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete commands.)

Download View All Tasks