0 Replies Latest reply: Sep 4, 2015 6:14 AM by aanchal bhatia RSS

    incremental load in salesforce

      Hi,

      Could anyone tell me how to implement incremental load in salesforce?

       

      $(varTableName)_SQL:

      SQL Select *

      FROM $(varTableName)

      WHERE LastModifiedBy >=$(vLastExecTime) and LastModifiedBy < $(vExecTime);   //***************************Change the "LastModifiedDate" to the name of the field for the last modified data time stamp in your tables.

       

       

      The following error occurred:

      There is no open data connection. Missing or failed "CONNECT" statement.

       

                     

      thanks!