MS BI Studio 2014 square brackets

[hamishredmond]

I am using devart dotnet connector when creating a data source. When I use this data source when creating a data source view and try and save the view I get an error:
"You have an error in your SQL Syntax; check the manual that corresponds t your MYSQL server version for the right syntax to use near '[riskanalyzercontrolresponse] limit 0,0' at line 2."
It seems to have put square brackets around the underlying MYSQL table name. This appears to have been a problem with this since 2009 - is there a fix out there somewhere?
Would appreciate your comments asap

Thank you

[Shalex]

Standard components (ADO NET Source and ADO NET Destination) do not take into account peculiarities of MySQL server. Our provider includes MySQL-specific SSIS components: Devart MySQL Source and Devart MySQL Destination.

Unfortunately, SSDT-BI for Visual Studio 2013 is currently not supported. We will notify you when the corresponding support is implemented.
As a temporary workaround, please use the dotConnect for MySQL SSIS components in VS 2008, 2010, or 2012.

[Shalex]

The new build of dotConnect for MySQL will include the following improvements:

• Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
• SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013

We will notify you when the corresponding build is available for download.

[Shalex]

New build of dotConnect for MySQL 8.3.379 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=2&t=31497.