Compatibility Issues with SSIS & SSAS 2005

reinier · 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?

Alexey · 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.