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.