- Thank you received: 0
Cannot read from PostgreSQL Materialized views from SSIS
- DJs
- Topic Author
- Offline
- User
-
Less
More
2 years 10 months ago #14578
by DJs
Cannot read from PostgreSQL Materialized views from SSIS was created 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?
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.
- admin
- Offline
- Admin
-
Less
More
- Thank you received: 8
2 years 10 months ago #14579
by admin
Replied by admin on 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.
- DJs
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
2 years 10 months ago - 2 years 10 months ago #14583
by DJs
Replied by DJs on 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?
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.
- admin
- Offline
- Admin
-
Less
More
- Thank you received: 8
2 years 10 months ago #14584
by admin
Replied by admin on 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.159 seconds