topic Re: Multi Part Identifier Could Not Be Bound in Mssql Server in Talend Studio

Multi Part Identifier Could Not Be Bound in Mssql Server

Ray0801 — Fri, 15 Nov 2024 23:49:16 GMT

I am storing a date in a context variable date

context.xxxDate.

When I try to write it inside a query.

Select * from Source_Table Where Date_Field > context.xxxDate and When I run the job.

I am getting

Multi Part Identifier Could Not Be Bound error. Is there anything wrong with the syntax.

Exception in component tDBInput_1 (xxxxxxxxx_Job)

java.sql.SQLException: The multi-part identifier "context.xxxDate" could not be bound.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)

Anonymous — Thu, 26 Aug 2021 06:53:03 GMT

Hello,

Please make sure there is no any missed single quote around your variable.

Best regards

Sabrina

Ray0801 — Thu, 26 Aug 2021 12:37:55 GMT

@Xiaodi Shi That was the case,I forgot single quotes around my variable.

Anonymous — Fri, 27 Aug 2021 03:50:14 GMT

Hello,

Great it works. Thanks for letting us know it.

Best regards

Sabrina