You are here:

Creating A Target Variable

Target variables allow you to reference a value from a target field that can then be used in formulas in other target steps.

To Create A Target Variable

Do one of the following in Workbench to open the Target User Variable Properties dialog box:
- From the menu:
  1. Click View > User Variables. The Variables dialog box appears.
  2. Click Add Target.
- From the Target pane:
  1. Right-click a linked field and select Edit Lookup Criteria. The Edit Lookup Criteria for the selected field appears.
  2. Click Edit Lookup Formula. The Edit Formula for the selected field appears.
  3. Click Show User Variables.
  4. Click Add Target.
Click Add Target. The Target User Variable Properties dialog box appears.
Enter a name for the variable in Variable Name.
If this DTS has more than one target connection, select the connection that contains the data object or step for this variable from the Target Connection drop-down list.
Specify the filter type, either Data Object or Step:
- Data Object — Only show unique data objects used in the any of the configured steps.
- Step — Show all data objects used in the current step configuration. If an object is used in more than one step, multiple instances of that object appear.
Select from the Field drop-down list a field of the data object or step you selected in step 4. This field or value can be used in formulas for subsequent steps.
Note: Because Target Variables do not support binary data, binary target fields are not included in the list.
Optionally, enter Help Text that describes the variable.
Click OK. If any required information is missing or if any invalid values were provided, a message appears. Otherwise, the new variable appears under User Variables in the Variables dialog box.