SSIS Data Transfer

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 1
Joined: Thu 16 Aug 2007 15:31

SSIS Data Transfer

Post by maj » Thu 16 Aug 2007 15:38

I am evaluating the PostreSQLDirect .NET data provider, specifically to use with the Microsoft BI functions of SQL Server 2005. I am trying to perform an ETL function to transfer data from a Postgres db to SQL Server.

I have the PostreSQLDirect .NET data provider (v. 3.20 beta) installed locally and on the SQL Server. When I attempt to use the SSIS Import and Export, I am not able to use the "Copy data from one or more tables or views" option as it is greyed out. In reading through the MS docs, this usually happens when using an ODBC connection.

Should I be able to use the PostreSQLDirect .NET data provider in this manner?


Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 17 Aug 2007 08:11

It is impossible to enable this option, unfortunately. It is valid for SqlClient only.

Post Reply