This process can work for both Microsoft SQL Server & Oracle.  There are separate attachments for each of these.

Steps to Implement Incremental Load by ID

1. Create a custom procedure (code attached)


2. In load table job description enter something like this:

Where accountid is the column name of the sequential id.

3. In Where Clause (Source) add:


    WHERE accountid > $Pload_accounts_accountid$

4. Create a parameter:

    name: 'yourloadtable_yourid'

    value: some id

    comment: Last MAX accountid Processed

5. In your job:

    ……Some tasks…..

    execute update_last_seq_id_parameter (attached) this will capture the MAX accounted and will use it in the WHERE clause during next run