You can translate the question and the replies:

Using SSIS to source Data from Denodo

I am sourcing data from Denodo using SSIS, I am getting the error below and I dont have an idea what i could be doing wrong, Please assist. [ADO NET Source [2]] Error: System.Data.OleDb.OleDbException (0x80040E14): ERROR: Syntax error: Exception parsing query near 'declare' DETAIL: java.sql.SQLException: Syntax error: Exception parsing query near 'declare'
@data-server @primavera @wsdl Bulk Data Load 'Java heap space' AWS HIVE JDBI Connection URI DENODO SSIS SSIS
user
17-09-2019 04:12:08 -0400
code

1 Answer

Hi, From the error description, it seems like this error would occur if you use a invalid VQL syntax in the **SQL command text** of the ADO.NET Source Editor (In SSIS tool) . **Declare** is not a valid statement in VQL expression, you could use the valid VQL expression and connect to the Virtual DataPort server. For more details about the query compatibility, you can refer to [VDP Conformance with Standard SQL](https://community.denodo.com/kb/view/document/VDP%20Conformance%20with%20Standard%20SQL?category=VQL) Knowledge Base article. Hope this Helps!
Denodo Team
18-09-2019 08:51:59 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here