The Data Formulas tab at the bottom of the main window lists all the
Data Links and Fixed Value links established for the current DTS file,
or the selected step, including any formulas applied to these links.
To add or edit a formula
On the Data Formulas tab, right-click the row and select Edit
Data Formula from the popup menu. You can also select multiple
rows to change
formulas on multiple links.
To view or edit a link comment:
Double-click the Comment
column. The Link Comment window appears.
To change the Overwrite
option
Double-click in the Overwrite
column of a link to toggle Overwrite on and off. An asterisk (the
default) indicates that if there is data in the target field, new source
data will overwrite it.
Tip: To resize columns, drag the dividers
between the column headings.
To sort columns in the Data
Formulas tab, click the column headers.