Data load: want to redirect extant rows in table to a file

We are working on a DataWarehouse app. The DW has been loaded wiith transactional data from the start of September. and we want refresh the DW with a full load from the original source. This full load wil consist largely of the same records that we loaded initially in the DW but some records will be new and others will have changed.

During the load I want to direct input records NOT already in the DW to a "mods" table and ignore those input records that alreayd exist in the DW. Can SSIS help out with this task?

TIA,

Barkingdog

Use a lookup task to compare the input with the existing table. Redirect errors to the "mods" table and ignore all records where the lookup succeeds.