MS BI Studio 2014 square brackets

MS BI Studio 2014 square brackets

Postby hamishredmond » Wed 02 Jul 2014 01:10

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
hamishredmond
 
Posts: 1
Joined: Wed 02 Jul 2014 01:03

Re: MS BI Studio 2014 square brackets

Postby Shalex » Wed 02 Jul 2014 11:34

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
Devart Team
 
Posts: 7475
Joined: Thu 14 Aug 2008 12:44

Re: MS BI Studio 2014 square brackets

Postby Shalex » Wed 25 Mar 2015 14:18

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
Devart Team
 
Posts: 7475
Joined: Thu 14 Aug 2008 12:44

Re: MS BI Studio 2014 square brackets

Postby Shalex » Thu 26 Mar 2015 17:22

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.
Shalex
Devart Team
 
Posts: 7475
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL