MRS
asked on
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)
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)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.