Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
am attached my script and error screen shot .please find the attachment.
Thanks & regards
raja
Hi raja,
looks like your variable isn't being handled as expected, try single quotes around it in your where clause
'$(vLastDateUpdate)'
Joe
Use
Where LASTUPDATE > '$(vLastUpdateDate)';
Hi Joe,
when am loading the sql table.where clause not working on that table
same error occured
Try adding a TRACE command just before your Incremental_Load1 load to see if your variable is being set.
TRACE vLastUpdateDate = $(vLastUpdateDate);