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

The TargetMode parameter specifies the mode of injection to be used. "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. The default behavior is to Merge.