SSIS PostgreSQL Source

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.

Features

Multiple modes (i.e. Table or Query) to read data from PostgreSql Database
Support for data preview and max rows
Support for variable placeholders in sql query
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Click here to see articles related to PostgreSql

Watch this video on YouTube

PostgreSQL Connection Manager

Enter connection attributes to connect to PostgreSQL instance and Click Test connection to verify credentials

PostgreSQL Source Connector – Query data using SQL

Articles / Tutorials

Click here to see all articles for [SSIS PostgreSQL Source] category

Export PostgreSQL Table Data to SQL Server in SSIS

ZappySys provides high performance drag and drop connectors for PostgreSQL Integration. In this post you will see how to Export PostgreSQL Table Data to SQL Server Table usingÂ SSIS PostgreSQL Source. PostgreSQL SourceÂ supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance. […]

Load PostgreSQL Table Data to CSV File in SSIS

Introduction ZappySys provides high performance drag and drop connectors for PostgreSQL Integration. In this post you will see how toÂ Load PostgreSQL Table Data to CSV File usingÂ SSIS PostgreSQL Source. PostgreSQL SourceÂ supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance. In […]