Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

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


Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...