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'

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]( Knowledge Base article. Hope this Helps!
Denodo Team
18-09-2019 08:51:59 -0400
You must sign in to add an answer. If you do not have an account, you can register here