SSIS Data Transfer

SSIS Data Transfer

Postby 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?

Thanks.
maj
 
Posts: 1
Joined: Thu 16 Aug 2007 15:31

Postby Alexey » Fri 17 Aug 2007 08:11

It is impossible to enable this option, unfortunately. It is valid for SqlClient only.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL