SSIS PostgreSQL Destination - Perform bulk Insert/Update/Delete/Upsert data in PostgreSQL Table

Learn how to read data from Source and load into PostgreSQL Table in SSIS (Using UPSERT Destination)

01:02 Create Table using Query in PostgreSQL
04:04 PostgreSQL Bulk Insert
06:12 PostgreSQL Bulk Upsert

SSIS PostgreSQL Destination
=========================================
PostgreSQL Destination can be used to bulk insert/update/delete/upsert large amount of records to a PostgreSQL Table from any data source using SSIS. PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance

Features
==========================================
* Supports connection with PostgreSQL
* Supports custom batch size to fine tune load performance
* Support for advanced error handling such as throw error for empty file, throw error when column count mismatch
* Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

Related Searches:
===========================================
Load data into PostgreSQL Table
Import REST API data into PostgreSQL Table
Upsert into PostgreSQL Table
Insert into PostgreSQL Table
Update into PostgreSQL Table
Delete into PostgreSQL Table