Data Replication 2
Results 1 to 2 of 2

Thread: Deletes as Inserts

  1. #1
    Philip.Kettlewell is offline Junior Member
    Join Date
    Mar 2011
    Location
    Australia
    Posts
    1
    Rep Power
    0

    Deletes as Inserts

    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

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •