SSIS Connectivity to Greenplum

12 years 8 months ago #2085 by piduruviswa
SSIS Connectivity to Greenplum was created by piduruviswa

I just downloaded PGNP OLEDB Eval version. I am trying to load data from Flat file to Greenplum Database using Microsoft SSIS package.

In SSIS, I choose PostgreSQL OLEDB as provider and test connection succeeded but while listing the tables from the Select Table & Views drop down list I got error "Unspecified Error: E_OUTOFMEMORY(0x8007000E)

This seems to be a known issue. Could some one please let me know if there are any work arounds available at the earliest. [img][img][/img][/img]Attached the screen shots

TITLE: Microsoft Visual Studio

Could not retrieve the table information for the connection manager ''.

Unspecified error: E_OUTOFMEMORY(0x8007000E)


Unspecified error: E_OUTOFMEMORY(0x8007000E) (PgOleDb)




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

12 years 8 months ago #2086 by Moderator
Replied by Moderator on topic Re: SSIS Connectivity to Greenplum
Would you please send us the table(s) schema to help us reproduce the issue?

Update: We have not been able to repro the issue. Please make sure that "Allow inprocess" option is selected in PGNP Provider properties in SSMS. It is a most common reason for various issues. Read Developers Manual for more information.

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

Time to create page: 0.142 seconds
Powered by Kunena Forum