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)