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.

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
- 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.
- Open an Integration Services project in Visual Studio. The Devart PostgreSQL components appear in the SSIS Toolbox.
- 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.
- 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.
- 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
| License | 1-year subscription | Perpetual | What it covers |
|---|
| Developer | $179.95 | $349.95 | One developer's machines, for development and testing |
| Server | $449.95 | $899.95 | One server running packages, plus one developer |
| Site for 10-100 Devices | On the order page | $999.95 | Unlimited 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