Solved

Moving Data from Postgres to Sql Server using SSIS

Posted on 2014-09-18
2
1,035 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 46

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now