The TargetMode parameter specifies the mode of injection. "Purge" clears the target of any records before beginning the injection. ...

The TargetMode parameter specifies the mode of injection. "Purge" clears the target of any records before beginning the injection. "Merge" checks each item to see if it exists prior to writing it to the target. "Append" copies all records to the target location.