SSIS PostgreSQL Source
Extract large amounts of data from a PostgreSQL database with a table or a SQL query.
PostgreSQL Source extracts large amounts of data from a PostgreSQL database, in Table mode or with a SQL query. PostgreSQL is a powerful, open source relational database with a strong reputation for reliability, feature robustness and performance.
The trial includes PostgreSQL Source and every other PowerPack component
- Data Flow Source in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial
At a glance
What PostgreSQL Source can do
PostgreSQL Source can be used to extract large amount of data from a PostgreSQL Database. This component supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance.
Table or query mode
Read data from a PostgreSQL database in Table mode or with a SQL query.
AccessMode: Table or QueryTableNameorQuery
Data preview & query examples
Preview the data before you run the package.
- Preview button in Table and Query mode
- View Examples for ready-made queries
Row limit
Limit how many rows are fetched from the source.
MaxRows: 0 = unlimited
Variable placeholders
Make the SQL query dynamic with SSIS variable placeholders.
- Example:
WHERE "CustomerID" = '{{User::CustomerID}}'
Column selection
Choose which columns to output on the Columns tab.
Error output
Redirect bad rows to the error output along with the exact error reason.
- RedirectRow on error or truncation
- By default the component fails on any data error
PostgreSQL connection
Connect with host, port, database, user name and password through the PostgreSQL Connection Manager.
- Enable SSL
- Connection pooling and
RetainSameConnection - Separate command and connect timeouts
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
Logging
Control what is logged during package execution.
LoggingMode: Normal, Medium, Detailed or DebuggingPrefixTimestampadds a timestamp to log messages
See all features
- Extract a large amount of data from a PostgreSQL database
- Multiple modes (Table or Query) to read data from a PostgreSQL database
- SQL language to query PostgreSQL data
- Support for data preview and max rows
- Support for variable placeholders in SQL query
- Ready-made query examples in the UI
- Select output columns on the Columns tab
- Error output to redirect bad rows with the error reason
- 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
- Load PostgreSQL data to SQL Server or CSV files
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 Source page and help file, with the screens you will see in SSDT.
PostgreSQL Connection Manager
Right-click the Connection Managers panel, choose New Connection and pick ZS-POSTGRESQL.
Enter the host, port, database, user name and password (enable SSL if needed) and click Test Connection to verify the credentials.
PostgreSQL Source – Query data using SQL
Set AccessMode to Query and write the SQL. Use SSIS variable placeholders to make it dynamic, for example WHERE "CustomerID" = '{{User::CustomerID}}'.
Click Preview to check the data. Set MaxRows to limit how many rows are fetched (0 = unlimited).
Read a table in Table mode
Double click on PostgreSQL Source to configure it.
In the PostgreSQL Source, select connection we have created, set Access Mode to Table and select table that you want to use as source.
- Click Preview to see a data preview.
- On the Columns tab, select the columns you want to output.
PostgreSQL Source – Properties
Component properties: AccessMode (Table or Query), TableName, Query, MaxRows (0 = unlimited), LoggingMode and PrefixTimestamp. The component also supports an error output to redirect bad rows.
Inside the UI
Key settings, as they appear in SSDT.
Real screens from the PostgreSQL Source product page. Step through them, or open any shot at full size.
PostgreSQL Connection Manager
Enter the host, port, database, user name and password, then click Test Connection to verify the credentials.
Articles
Worked examples that use PostgreSQL Source.
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 Source on the canvas.
What is PostgreSQL Source?
PostgreSQL Source extracts large amounts of data from a PostgreSQL database in an SSIS Data Flow. It supports the SQL language to query PostgreSQL data, through the ZappySys PostgreSQL Connection Manager.
What can PostgreSQL Source do?
It reads data in Table or Query mode, with data preview, a MaxRows limit (0 = unlimited) and SSIS variable placeholders in the SQL query. You pick the output columns on the Columns tab, and bad rows can be redirected to the error output.
How do I pass an SSIS variable into the query?
Use a placeholder in Query mode, for example SELECT "OrderID", "OrderAmount" FROM public."tbl_pg_Orders" WHERE "CustomerID" = '{{User::CustomerID}}'. The value is inserted at runtime.
What happens on a data error or truncation?
By default the component fails on any data error or truncation. Attach the error output and set RedirectRow on error and truncation to capture bad rows along with the exact error reason.
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.
What customers say
Start your free trial today
Install SSIS PowerPack and drag PostgreSQL Source onto the Data Flow.
Extract large amounts of data from a PostgreSQL database with a table or a SQL query.
- Data Flow Source in SSISPostgreSQL Source 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.