Cannot read from PostgreSQL Materialized views from SSIS

More
1 month 5 days ago #14578 by DJs
DJs created the topic: Cannot read from PostgreSQL Materialized views from SSIS
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
1 month 5 days ago #14579 by admin
admin replied the topic: Cannot read from PostgreSQL Materialized views from SSIS
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
1 month 4 days ago - 1 month 4 days ago #14583 by DJs
DJs replied the topic: Cannot read from PostgreSQL Materialized views from SSIS
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: 1 month 4 days ago by DJs.

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

More
1 month 3 days ago #14584 by admin
admin replied the topic: Cannot read from PostgreSQL Materialized views from SSIS
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.099 seconds
Powered by Kunena Forum