• I did some testing.

    added the reprocessing column option to the cdc source.

    Performed a couple changes in DDL and DML over the tracked table.

    Ran the CDC update package which failed. The time out was 520 for the test.

    The incremental CDC package would now fail with 1 warning about reprocessing mode and a time out error.

    Truncating the target table and running a 10 min initial load was the only way I found to get the incremental update to work again.

    BI Guy