I need to move all records from salesforce to a DWH using SSIS.

After the initial run I need to move only the records that either got inserted or updated after the last run into SFDC.

I learnt that SystemModstamp changes everytime a modification/Insert occurs.

Now how do I retrieve only the latest records using the object filter option available with salesforce Source Component provided by CozyRoc. ?

I've a Audit Table which stores the LOG Details of the package like PACKAGE_START_TIME,END_TIME etc...

Thanks, Vijay


LAST_WEEK ; LAST_N_DAYS:n ; N_DAYS_AGO:n are some of the Criteria's you can use while filtering in salesforce source...

SystemModstamp>LAST_WEEK Check the below link for more:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.