Multi Part Identifier Could Not Be Bound in Mssql Server

[Ray0801]

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 · Accepted solution]

Hello,

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

Best regards

Sabrina

[Ray0801]

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

[Anonymous]

Hello,

Great it works. Thanks for letting us know it.

Best regards

Sabrina