Add a script variable
It is best practice to use 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 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.
Important 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.