Add a Script Variable
It is best practice to use the Transformation Designer to add and delete variables, as the script has to be changed accordingly. To change the value of a variable you can either do so within the Transformation Designer or use a text editor to edit the external script variables XML file.
-
On the Ribbon
Project tab, in the
Configuration group, select
Script Variables
.
The Script Variables window is displayed.
-
Click
Add
.
An editable variable is added to the table where the default name is "Variable <n>," where <n> is a unique number. This ensures that no two variables have the same name.
- Type a Name for the new script variable.
-
Click in the
Value column for the new
field and type a value for the variable.
The script variable is a string type, so the variable is saved as a string.
- Click OK to save your changes and close the Script Variables window.
- Save the changes to your project.