We use tdv 8.3 (latest version) ADO connectors in SSIS. When we write an Inner JOIN query we get an error below

[Michael Boadi]

Malformed SQL Statement: Expected token "JOIN" but found ESCInitiator with value '9' instead at position 526.

Staement: SELECT

PlanNumber

From ( SELECT DISTINCT PlanNumber FROM XXX WHERE CreatedDate = (Select MAX(CreatedDate) FROM XXX

) Plan

INNER {option semijoin - "True"}JOIN

DC.Plans.RecurringAdvisorFee

ON Plan.PlanNumber =DC.PlanNumber

Error at CE REC ADV FEE[TDV [35]]: efo 190B OR" Malformed SQL Statement: Expected token 'JOIN' but found ESCInitiator with Value "{"nstead of position 526.