Incremental Load

[#1]

Hi All,

I'm trying to do a Insert and Update Incremental Load but it's unable to function. I have two date fields in my DB table (insert date and update date) and I'm using the update date as the modified date. Please find attached the copy and please provide assistance in implementing it.

Thanks in Advance,

[sunny_talwar]

When you say it is unable to function, are you getting some kind of error? What isn't working?

[#3]

Thanks for the speedy reply Sunny.

[sunny_talwar]

vLastRunTime variable needs to be formatted correctly.

vLastRunTime = Date(Today(), 'DD-MMM-YYYY')

[#5]

I'm getting the above error.

[sunny_talwar · Accepted solution]

Can you add single quotes around  the variable?

Where updatedate > '$(vLastRunTime)'

[#7]

Thanks Sunny for all your help.