Manage script variables
Use the procedure in this topic to 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.
If you edit the XML file outside of the Transformation Designer, you need to ensure that it is saved in UTF-8 format. If you use Notepad and save it as ANSI, it can corrupt the XML file.
-
On the Ribbon
Project tab, in the
Configuration group, select
Script Variables.
The Script Variables window is displayed.
-
In the
Script Variables window, use the following buttons to manage the
Name and corresponding
Value of your script variables.
Setting
Name and Description
- Add
-
Adds a new script variable to the list.
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.
- Delete
-
Removes the selected script variable from the list.
- Reload
-
Reloads the <ProjectName>_ScriptVariables.xml file and updates the list of script variables if the file is modified while the project is open.
- Select OK to save your changes and close the Script Variables window.
- Save the changes to your project.