• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1318
  • Last Modified:

Moving Data from Postgres to Sql Server using SSIS

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
MRS
Asked:
MRS
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
You can use Oledb drive for Postgre for 32 and 64 bit and try it to do so.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now