Modifying The Overwrite Option

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

  1. Select the Data Formulas tab in the main window.
  2. Select a link (row) on the tab.
  3. Double-click the Overwrite column for that row to toggle Overwrite on or off.

    When Overwrite is on, an asterisk (*) appears in the column, and data in the target field will be updated.

See also

Creating Fixed Value Links

Operations

Data Formulas tab