Solved

Moving Data from Postgres to Sql Server using SSIS

Posted on 2014-09-18
2
1,122 Views
Last Modified: 2016-02-11
I am running SQL Server 2008 and trying to import about 64 million rows from Postgres to Sql Server. I am using SSIS to accomplish this. I have setup an ADO.NET source and used the “Net Framework Data Provider for Odbc” to configure the Postgres driver.

When I test the connection, the connection succeeds. However, when I try to configure the Data Access mode and select Table or view I get the error below:

"Could not retrieve the table information fo rthe connection manager" Object reference not set to an instance of an object. (Microsoft.DataWarehouse)
0
Comment
Question by:MRS
2 Comments
 
LVL 49

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 40332053
You installed the Postgres client in the SSIS machine? If so you should use the Postgres native client for the connection instead of the ".NET Framework Data Provider for Odbc”
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 250 total points
ID: 40336268
You can use Oledb drive for Postgre for 32 and 64 bit and try it to do so.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question