Cannot read from PostgreSQL Materialized views from SSIS

More
2 years 10 months ago #14578 by DJs
I am trying to load records from PostgreSQL Materialized view (source) into SQL server 2012 table say schema.table(destination) using SSIS.
We are using the IntelliSoft OLE DB provider for PstgreSQL version 1.4.0.3542 in the DEV server.
It is failing giving the message "Undegined table schema.table".
Is it not possible to read from PostgreSQL Materialized views from SSIS?

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #14579 by admin
Materialized views are supported starting build 3582. The provider can be upgraded using PGNPUpdate utility during active support period.
The following user(s) said Thank You: DJs

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago - 2 years 10 months ago #14583 by DJs
Thanks for the reply.
we have a licensed version 1.4.0.3542 installed in the servers.
is the upgrade to the latest version 1.4.0.3612 free?
Last edit: 2 years 10 months ago by DJs.

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #14584 by admin
Upgrades are free during active support period. Feel free to check the license support status at Products\License Status page on our website. If annual support expired, it can be renewed on the Purchase page.

Please Log in or Create an account to join the conversation.

Time to create page: 0.159 seconds
Powered by Kunena Forum