In the Workbench, invalid links appear on the Data Formulas tab in red, with cell references given as
"?n," rather than S4, for example.
In the Workbench, with a DTS open, click the Data Formulas tab.
If the Data Formulas tab is not visible at the bottom of the main window, click the expand button at the bottom of the window ().
Double-click the row of the invalid formula.
The Edit Formula dialog box appears.
The row numbers of invalid formulas appear as "X."
Correct the invalid formula.
The "?" in the formula indicates the invalid
cell reference that requires editing.
Note: Use Show Source Fields and Show Invalid Fields to compare the reference in the previous
source to the reference in the new source.
As you correct errors in formulas, the "?" is replaced by a valid
numerical row reference.
Note: Important! Edit any
invalid references during the current session, before saving and closing
the job. If you save and close the DTS without editing any invalid references, the Show
Invalid Fields button is unavailable when you next open
the DTS.
).