SSIS PostgreSQL Destination Adapter

PostgreSQL Destination can be used to perform bulk insert in PostgreSQL Table from any data source using SSIS.

Features

Supports connection with PostgreSQL
Supports custom batch size to fine tune load performance
Provide truncation warning during validation if data length mismatch occur between source and destination
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Click here to see articles related to PostgreSql

Watch this video on YouTube

Create new PostgreSQL connection

Supports the new ZS-POSTGRESQL Connection.

Configure PostgreSQL Connection

Connects to the ZS-POSTGRESQL connection where you can configure, server, ports, user and password.

Select PostgreSQL destination Connection

In connection manager, you can select your connection

Configure PostgreSQL destination Target settings

SSIS PostgreSQL detination allow to select the table, configure batch size and the Logging Mode.

Configure PostgreSQL destination Mapping settings

Using SSIS OAuth Connection Manager in JSON Source – Read data from REST API via OAuth 1.0 or OAuth 2.0

Articles / Tutorials

Click here to see all articles for [SSIS PostgreSQL Destination] category

Load data into PostgreSQL from Excel file using SSIS

Introduction In this post, we will learn How to Load data into PostgreSQL from Excel file using SSIS PostgreSQL Destination.Â We will useÂ SSIS PowerPackÂ to connect PostgreSQL. This article also covers how to read Excel file in SSIS. SSIS PostgreSQL DestinationÂ can be used to perform bulk insert in PostgreSQL Table from any data source using SSIS. […]