Compatibility Issues with SSIS & SSAS 2005

[reinier]

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?

[Alexey]

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.