'cannot access Postgres views from SSIS thru ODBC PSQL driver

I'm working with Postgres from SSIS thru ODBC Unicode driver ver 13.01. 32-bit connection.

I can successfully connect to all Postgres tables but can not able to see any view thru that connection.

How can I access to Postgres views from SSIS?

sql-serverpostgresqlviewssisodbc


Solution 1:[1]

I just tried using the SQL Server import wizard (which uses a subset of SSIS) and I also could not see any views in the list of "Tables and views" for my PostgreSQL database

enter image description here

but when I chose the "Write a query to specify the data to transfer" and entered

SELECT * FROM view1

for the "SQL statement" it allowed be to import the view data into a SQL Server table.

Solution 2:[2]

I had a similar problem because the view belonged to another user and the search context in postgres was not set for my ssis-login user.

Regards

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Gord Thompson
Solution 2 stj-fr

Related Questions