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?