getting error while doing incremental load

Sun, 07 Feb 2016 09:40:26 GMT

Hi Guys,

I am loading the data from sql server,i have a field callled DOJ and the datatype is date ,that means it displays date

as yyyy-mm-dd,..while i am doing incremental load it gives me an error ..the error is operand type clash date is incompatile

with int.my script for incremental load is

IncLoad:

LOAD id,

name,

date(Selectdate) as Selectdate;

SQL SELECT *

FROM NORTHWND.dbo.IncTest where Selectdate>=$(vModDate);

LOAD id,

name,

Selectdate

FROM

(qvd) where not exists(id);

could anyone suggest me..

Re: getting error while doing incremental load

marcus_sommer — Sun, 07 Feb 2016 12:21:16 GMT

Try the variable with single-quotes: Selectdate>='$(vModDate)'

- Marcus