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.

Procedure
  1. On the Ribbon Project tab, in the Configuration group, select Script Variables icon Script Variables.

    The Script Variables window is displayed.

  2. 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 icon

    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 icon

    Delete

    Removes the selected script variable from the list.

    Reload Script Variable icon

    Reload

    Reloads the <ProjectName>_ScriptVariables.xml file and updates the list of script variables if the file is modified while the project is open.

  3. Select OK to save your changes and close the Script Variables window.
  4. Save the changes to your project.