By default, target data is overwritten during Update operations. You can change this option for any Data Link or Fixed Value Link in the DTS file.
The overwrite option is important for Insert/Update and Update/Insert steps. In these cases, an insert is always performed, but the data is updated only if the overwrite option is selected. If you turn overwrite off, the data link is not used on the update operation.
This is useful when you want to update some, but not all, of the fields in a step.
To change a Data Link's Overwrite status
When Overwrite is on, an asterisk (*) appears in the column, and data in the target field will be updated.
See also