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...