SSIS Connectivity to Greenplum
- piduruviswa
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
11 years 4 weeks ago #2085
by piduruviswa
SSIS Connectivity to Greenplum was created by piduruviswa
Hi,
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 '192.168.1.2.Vish'.
Unspecified error: E_OUTOFMEMORY(0x8007000E)
ADDITIONAL INFORMATION:
Unspecified error: E_OUTOFMEMORY(0x8007000E) (PgOleDb)
BUTTONS:
OK
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 '192.168.1.2.Vish'.
Unspecified error: E_OUTOFMEMORY(0x8007000E)
ADDITIONAL INFORMATION:
Unspecified error: E_OUTOFMEMORY(0x8007000E) (PgOleDb)
BUTTONS:
OK
Please Log in or Create an account to join the conversation.
11 years 4 weeks 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.
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.054 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- SSIS Connectivity to Greenplum