am using sql table in incremental load.am reload my script its following error is occured.can u please tell me where the problem?

[#1]

am attached my script and error screen shot .please find the attachment.

Thanks & regards

raja

[#2]

Hi raja,

looks like your variable isn't being handled as expected, try single quotes around it in your where clause
'$(vLastDateUpdate)'

Joe

[MK_QSL]

Use

Where LASTUPDATE  > '$(vLastUpdateDate)';

[#4]

Hi Joe,

when am loading the sql table.where clause not working on that table

[#5]

same error occured

[marcus_malinow]

Try adding a TRACE command just before your Incremental_Load1 load to see if your variable is being set.

TRACE vLastUpdateDate = $(vLastUpdateDate);