SSIS PostgreSQL Destination Adapter

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
  • Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see articles related to PostgreSql
SSIS Amazon SQS Source Connector - Video Tutorial
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Create new PostgreSQL connection

Create new PostgreSQL connection

Supports the new ZS-POSTGRESQL Connection.

Configure PostgreSQL Connection

Configure PostgreSQL Connection

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

Select PostgreSQL destination Connection

Select PostgreSQL destination ConnectionSelect PostgreSQL destination Connection

In connection manager, you can select your connection

Configure PostgreSQL destination Target settings

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

UConfigure 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

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. […]

Click here to learn more about System Requirements
Download View All Tasks Like This