SSIS PostgreSQL Destination
Bulk insert records into a PostgreSQL table from any data source using SSIS.
PostgreSQL Destination bulk inserts a large number of records into a PostgreSQL table from any data source using SSIS, through the ZappySys PostgreSQL Connection Manager.
The trial includes PostgreSQL Destination and every other PowerPack component
- Data Flow Destination in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial
At a glance
What PostgreSQL Destination can do
PostgreSQL Destination can be used to perform bulk insert in PostgreSQL Table from any data source using SSIS.
Bulk insert to PostgreSQL
Bulk insert a large number of records into a PostgreSQL table from any data source.
- Feed it from sources such as OLE DB, MongoDB Source, CSV File Source or Excel files
Batch size control
Set a custom batch size to fine tune load performance.
BatchSize: how many rows to process in each request
Table picker & auto-mapping
Pick the destination table from the TableName dropdown on the Component Properties tab.
- New, empty table: all input columns are mapped automatically
- Existing table: drag columns from the source list to the target list
Truncation warnings
Warns during validation when data length differs between source and destination.
PostgreSQL connection
Connect with server, port, database, user name and password through the PostgreSQL Connection Manager.
- Enable SSL
- Application name, command timeout and a full connection string
Connection performance
Tune how the connection behaves while the package runs.
- Connection pooling
RetainSameConnectionkeeps one connection open for multiple tasks- Separate command and connect timeouts
Logging & locale
Control what is logged during package execution.
LoggingMode: Normal, Medium, Detailed or DebuggingPrefixTimestampadds a timestamp to log messagesLocaleIDfor locale-sensitive data such as date and time
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
Upsert & delete
Need to update existing rows or delete? Use Upsert Destination, which supports PostgreSQL.
- Insert new records and update existing ones by key columns
See all features
- Bulk insert a large number of records into a PostgreSQL table from any data source
- Supports connection with PostgreSQL through the ZS-POSTGRESQL connection manager
- Custom batch size to fine tune load performance
- Pick the destination table from a dropdown; input columns are mapped automatically for a new, empty table
- Truncation warning during validation if the data length differs between source and destination
- SSL support on the PostgreSQL Connection Manager
- Connection pooling and
RetainSameConnectionto share one open connection across tasks - Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix
- Locale setting for date and time data
- Upsert or delete PostgreSQL rows with Upsert Destination
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Key steps from the PostgreSQL Destination page and help file, with the screens you will see in SSDT.
Create new PostgreSQL connection
Right-click the Connection Managers panel, choose New Connection and pick ZS-POSTGRESQL.
Enter the server, port, database, user name and password (enable SSL if needed) and click Test Connection.
Configure PostgreSQL Destination
Double-click PostgreSQL Destination and, on the Connection Manager tab, select the PostgreSQL connection.
On Component Properties, pick the destination table from the TableName dropdown and set BatchSize to tune load performance.
On the Mappings tab, a new, empty table gets all input columns mapped automatically; for an existing table, drag columns from source to target.
Settings UI
Component properties: TableName, BatchSize (rows per request), LoggingMode, PrefixTimestamp and LocaleID.
Inside the UI
Key settings, as they appear in SSDT.
Real screens from the PostgreSQL Destination product page. Step through them, or open any shot at full size.
Create new PostgreSQL connection
Pick the ZS-POSTGRESQL connection type for a new connection.
Articles
Worked examples that use PostgreSQL Destination.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop PostgreSQL Destination on the canvas.
What is PostgreSQL Destination?
PostgreSQL Destination bulk inserts a large number of records into a PostgreSQL table from any data source using SSIS. It connects through the ZappySys PostgreSQL Connection Manager (ZS-POSTGRESQL).
What can PostgreSQL Destination do?
It bulk inserts rows into the table you pick from the TableName dropdown, with a custom BatchSize to fine tune load performance. New, empty tables get all input columns mapped automatically, and validation warns about possible truncation when source and target data lengths differ.
How do I update or delete existing PostgreSQL rows?
Use Upsert Destination, which supports bulk upsert (update or insert) and bulk delete for PostgreSQL. See Load data into PostgreSQL – Upsert using SSIS.
Which sources can feed it?
Any SSIS source. The help mentions OLE DB Source, MongoDB Source and CSV File Source, and the ZappySys tutorials load Excel files and MariaDB tables.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
See also
More from SSIS PowerPack.
What customers say
Start your free trial today
Install SSIS PowerPack and drag PostgreSQL Destination onto the Data Flow.
Bulk insert records into a PostgreSQL table from any data source using SSIS.
- Data Flow Destination in SSISPostgreSQL Destination appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.