0 Replies Latest reply: Apr 9, 2013 5:43 AM by Quentin Budny RSS

    Incremental loading

    Quentin Budny

      Hello everybody,

       

      I've a little problem, I load a table from a data base like this:

       

      fim_PIANO_DI_PRODUZIONE:

      SQL SELECT *
      FROM fim.dbo."PIANO_DI_PRODUZIONE"
      order by ID_COMMESSA,DATA_ULT_RIC;

      STORE fim_PIANO_DI_PRODUZIONE

       

      No problem it's work but it's a big table so i want to load only the lines where the creation date are higher than the last execution!

      So I do :

      Let ThisExecTime = ReloadTime();

      PIANO_DI_PRODUZIONE:
      SQL SELECT *
      FROM fim.dbo."PIANO_DI_PRODUZIONE"
      WHERE DATA_ULT_RIC >= '$(ThisExecTime)';

       

      But it doesn't work, no lines loading. I think it's a problem of data beetween ReloadTime and DATA_ULT_RIC.

      DATA_ULT_RIC is in numeric like '38085,802407407' and the reloadtime '09/04/2013 05:45:12'.

      How can I match this two date?

       

      Thanks a lot for your Ideas/Answers!

       

      Quentin