Compatibility Issues with SSIS & SSAS 2005

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 1
Joined: Mon 04 Dec 2006 08:20

Compatibility Issues with SSIS & SSAS 2005

Post by reinier » Mon 04 Dec 2006 08:41

I'm using the PostgreSQLDirect .NET 2.50.22 Pro to connect to a PostgreSQL 8.1 database from SQL 2005 Integratation Services.

First I added a new DataSource and this seems to work fine. After I try to add a new DataSource View. When I add one or more tables to this view I get the following error message: syntax error at or near "[" (Microsoft Visual Studio)

When I check the PostgreSQL log I see that Visual Studio is trying to execute the following query: SELECT * FROM [public].[products]

Is there any solution known for this problem? When will there be a future release which tackles this compatibility issue?

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

Post by Alexey » Mon 04 Dec 2006 09:42

We do not plan to fully support MS SQL 2005 Integratation Services in PostgreSQLDirect .NET.
Anyway, i can't reproduce the problem you report. Try to remove square brackets manually if it's possible.

Post Reply