SSIS Data Flow Components for PostgreSQL
SSIS Data Flow Components for PostgreSQL icon

SSIS Data Flow Components for PostgreSQL

by Devart
$179.95
Version
5.1.49
License
Shareware
Trial Limitations
Fully functional 30-day trial. The download needs a free Devart account
Operating Systems
Windows Vista and later, 32-bit and 64-bit
System Requirements
SQL Server Integration Services 2008 to 2025, Visual Studio with SSIS projects, .NET Framework 4.5, PostgreSQL 8.0 to 18 (no PostgreSQL client needed)
File Size
618.60 MB
Release Date
8/17/2026
Last Updated
11/17/2026
11 views 0 downloads
Devart SSIS Source, Destination and Lookup components for PostgreSQL

SSIS Data Flow Components for PostgreSQL: PostgreSQL Source, Destination and Lookup for SSIS

Devart SSIS Data Flow Components for PostgreSQL add a PostgreSQL Source, Destination, Lookup and Connection Manager to SQL Server Integration Services, for $179.95 a year (Developer license) or $349.95 perpetual. They connect straight to PostgreSQL 8.0 through 18 with no client library or ODBC driver, and the Destination bulk-loads with PostgreSQL's own COPY command.

Moving data between SQL Server and PostgreSQL in SSIS usually means an ODBC driver, a generic ADO.NET source and a lot of tuning before loads run at a decent speed. Devart's components are built for PostgreSQL specifically: a query editor that knows your schema, a destination that uses the fastest load path Postgres offers, and a lookup that batches and caches.

Quick facts

  • Version: 5.1.49, released August 17, 2026 (PostgreSQL 18 support arrived in 3.2, December 18, 2025)
  • Developer: Devart
  • Components: PostgreSQL Source, PostgreSQL Destination, PostgreSQL Lookup, PostgreSQL Connection Manager
  • Servers: PostgreSQL 8.0 to 18, EnterpriseDB, Pervasive Postgres
  • SSIS: SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019, 2022 and 2025
  • Platform: Windows Vista or later, 32-bit and 64-bit, .NET Framework 4.5
  • Download: 618.60 MB installer shared with the whole SSIS line; needs a free Devart account
  • Price: $179.95 a year or $349.95 perpetual for a Developer license; Server and Site licenses cost more
  • Trial: 30 days, fully functional
  • Refund: Devart's ordering FAQ gives a refund within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $179.95 for the Developer license with one year of updates on a yearly subscription, $349.95 perpetual, $449.95 a year for Server and $999.95 for a perpetual Site license, and the download page listed version 5.1.49 at 618.60 MB, on November 17, 2026. We didn't run a package against a PostgreSQL server

Download Free Trial Buy Now

Overview

After installation the four components appear in the SSIS Toolbox in Visual Studio. You add a Devart PostgreSQL Connection Manager with host, port (5432 by default), user, password, database and schema, then drop a Source, Destination or Lookup into a Data Flow task. Everything else works like native SSIS: the components feed and accept ordinary data flow paths, so PostgreSQL can sit on either side of a package next to SQL Server, flat files or any other source.

Devart PostgreSQL Source Editor in SSIS with tables, a SELECT query and a data preview

The Devart PostgreSQL Source Editor: the table tree on the left, a SELECT query that uses a package variable, and the Preview Data window showing the returned rows.

Features

A Source editor that knows your schema

The PostgreSQL Source in Devart SSIS Data Flow Components for PostgreSQL has its own editor that lists every table and column of the connection, builds a SELECT by drag and drop, and shows the package's system and user variables so you can insert them into the query. A Preview button runs the query and shows the first rows, so you can check the output before running the package.

Bulk loading with COPY

The PostgreSQL Destination in Devart SSIS Data Flow Components for PostgreSQL loads data with the PostgreSQL COPY command, the fastest way to insert large volumes into Postgres. It also supports the other DML operations, with settings for buffer size, bulk insert mode and retry count and interval when a load hits a transient error.

A Lookup that batches and caches

The PostgreSQL Lookup in Devart SSIS Data Flow Components for PostgreSQL checks several incoming rows with one SELECT (5,000 per batch in the example on Devart's page) and caches the results, cutting round trips to the server. Options cover case-insensitive matching, treating no match as an error, and taking the first match when there are several.

A connection manager with Postgres options

The Devart PostgreSQL Connection Manager in SSIS Data Flow Components for PostgreSQL connects without a PostgreSQL client and supports SSL (CA certificate, client certificate and key, SSL mode), SSH tunnels, HTTP proxies, protocol 2.0 or 3.0 for old servers, single sign-on through GSSAPI or SSPI, and connection pooling. Version 5.1.49 added SCRAM-SHA-256-PLUS authentication and PuTTY PPK3 SSH keys.

Benefits

  • Faster loads. COPY-based bulk loading beats row-by-row inserts through a generic ODBC destination.
  • Less setup. No PostgreSQL ODBC driver to install and match on every development machine and SSIS server.
  • Quicker package design. The Source editor's schema tree and preview save trips to a separate query tool.
  • Old and new servers. One component set covers PostgreSQL 8.0 through 18, plus EnterpriseDB.

Real-World Uses

  • Nightly PostgreSQL to SQL Server sync. An SSIS job copies orders from a PostgreSQL application database into a SQL Server data warehouse.
  • Loading Postgres from files. A package reads CSV exports and bulk-loads them into PostgreSQL tables with COPY.
  • Migration off SQL Server. A team moves tables from SQL Server to PostgreSQL in SSIS, reusing the ETL skills it already has.
  • Enriching data in flight. The Lookup matches incoming rows against a PostgreSQL customer table before they're written elsewhere.

Who It's For, and Who Should Skip It

These components suit SQL Server shops that already build ETL in SSIS and now have PostgreSQL in the mix, especially with large tables where load speed matters.

Skip them if you don't use SSIS: a Python script, Airflow or a cloud ETL service is a better fit outside the Microsoft stack. If you only move a few thousand rows now and then, SSIS's built-in ODBC source and destination with a free PostgreSQL ODBC driver may be enough. And if you'll connect to several systems, price the SSIS Universal Bundle first.

Usage Guide

  1. Sign in to Devart (a free account), download the installer from the product's download page and run it; select the PostgreSQL components and the SSIS versions you use.
  2. Open an Integration Services project in Visual Studio. The Devart PostgreSQL components appear in the SSIS Toolbox.
  3. In Connection Managers, add a new Devart PostgreSQL connection and enter host, port, user, password, database and schema; open Advanced settings for SSL or SSH.
  4. Drag a Devart PostgreSQL Source into a Data Flow task, pick tables in the editor or write a SELECT, and click Preview to check the rows.
  5. Connect it to a destination (or add a Devart PostgreSQL Destination when loading into Postgres), map the columns and run the package.

Before you buy

The Developer license covers development and testing on one developer's machines only. Running packages on a production SSIS server needs a Server license ($449.95 a year or $899.95 perpetual) or a Site license, so budget for that from the start. The trial installer is the 618 MB package for all of Devart's SSIS components.

Where it falls short

  • Windows and SSIS only. These components run inside SQL Server Integration Services on Windows; they're no use for ETL tools outside the Microsoft stack.
  • Server licenses add up. Each production server needs its own Server license unless you buy a Site license.
  • Large download. The installer is over 600 MB even if you only want the PostgreSQL components.
  • Few reviews. Only a dozen Capterra reviews cover the whole SSIS line, and none single out the PostgreSQL components.

What Users Say

Capterra

Review sites rate Devart's SSIS components as one product line rather than the PostgreSQL components alone. On Capterra, SSIS Data Flow Components average 4.6 out of 5 from 12 reviews, with 4.3 for ease of use and 4.3 for customer service. Reviewers describe the components as user-friendly and say Devart responded to their feedback. With so few ratings, test the trial on your own data before deciding.

Comparisons

PostgreSQL components vs. the SSIS Universal Bundle

The SSIS Universal Bundle ($499.95 a year or $999.95 perpetual on Devart's page) includes components for more than 40 databases and cloud apps, PostgreSQL among them. If you also connect to MySQL, Oracle, Salesforce or similar, the bundle is cheaper than buying three or more single sources; for PostgreSQL alone, these components cost far less.

Devart components vs. SSIS's ODBC source and destination

SSIS can reach PostgreSQL through its built-in ODBC components and the free psqlODBC driver, at no extra cost. Devart's components add COPY-based bulk loading, a batching Lookup, a schema-aware Source editor and SSH and SSL options in the connection manager, and remove the ODBC driver from every machine. Pay for them when load speed or package-building time matters.

Editions and Pricing

License1-year subscriptionPerpetualWhat it covers
Developer$179.95$349.95One developer's machines, for development and testing
Server$449.95$899.95One server running packages, plus one developer
Site for 10-100 DevicesOn the order page$999.95Unlimited computers in one company

Buy Now opens the order page for SSIS Data Flow Components for PostgreSQL; you choose the license, subscription or perpetual, a 1-, 2- or 3-year term and optional premium support there.

FAQs

Do I need a PostgreSQL ODBC driver or client for Devart's SSIS components?

No. Devart SSIS Data Flow Components for PostgreSQL connect directly to the server with their own connection manager, so no ODBC driver, libpq or other client software is needed.

Does it support PostgreSQL 18?

Yes. Devart SSIS Data Flow Components for PostgreSQL added PostgreSQL 18 in version 3.2 (December 18, 2025) and support every version back to 8.0.

Which SSIS versions does it work with?

Devart SSIS Data Flow Components for PostgreSQL work with SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019, 2022 and 2025.

Do I need a separate license for the production SSIS server?

Yes. The Developer license of Devart SSIS Data Flow Components for PostgreSQL covers development and testing only; deploying packages to a server needs a Server license or a Site license.

What happens when the subscription ends?

The subscription license of Devart SSIS Data Flow Components for PostgreSQL works for the term you paid for, so packages that use it need a renewal. A perpetual license keeps working at the version you have.

Can I get a refund?

Only for technical problems. Devart's ordering FAQ gives a full refund within 30 days of purchase when a bug or technical issue stops SSIS Data Flow Components for PostgreSQL working and support can't fix it. Use the 30-day trial against your own PostgreSQL server before buying.

System Requirements

  • Microsoft SQL Server Integration Services 2008, 2012, 2014, 2016, 2017, 2019, 2022 or 2025
  • Visual Studio with Integration Services projects for designing packages
  • Windows Vista or later, 32-bit or 64-bit, with .NET Framework 4.5
  • PostgreSQL 8.0 to 18, EnterpriseDB or Pervasive Postgres

Conclusion

Devart SSIS Data Flow Components for PostgreSQL are worth $179.95 a year to a team that builds SSIS packages around PostgreSQL and moves enough data for COPY-based loading and a caching Lookup to pay off. Remember to add a Server license for production. If you only move small amounts occasionally, SSIS's ODBC components with a free driver will do, and if PostgreSQL is one of many sources, the Universal Bundle is better value.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.

Related Videos
Practical SSIS Webinar: Integration MySQL, PostgreSQL, Salesforce, and Zoho Books data
Practical SSIS Webinar: Integration MySQL, PostgreSQL, Salesforce, and Zoho Books data

Video Length: 55:33
Uploaded By: Devart (11/6/2024)
View Count: 240

Copyright © 2026, Ivertech. All rights reserved.