Deletes as Inserts

[Philip.Kettlewell]

How do I configure the oracle-cdc for ssis to insert deletes in to the target with an operation of DELETE, also treating updates as inserts with an operation of UPDATE.

At the moment the deletes in the source are deleting in the target, which does not allow me to track the changes.

Basically everthing is an insert into the target.

I configured out of the box and cannot see an option to allow this.

thanks
Phil

[Gadi.Farhat]

Hi Philip,

The CDC packages, created using the package builder wizard, include data flow tasks that use a CDC Source component to read the changes captured for a table and a CDC Destination component that apply the change to a destination table.

If you don't want to apply the changes on the destination table and instead, you want to insert the changes to a target table, then you can simply replace the CDC Destination component with a standard SSIS destination component, for example, an OLEDB Destination component.


Regards,

Gadi