In the Properties view of the variable assignment operator, you can specify the source of variable values. You can type or select values in a variable assignment table, or read the variable values from an external delimited file.
Often in data warehousing environments, you need to export the results of a data flow to a file, then read values from a file, and assign values to variables. You use the read from file option in the variable assignment operator to complete this task.
The values that are read from an external delimited file, take precedence over the values in the variable assignment table.
The following figure shows a variable assignment table that contains three variables and their assigned values. The variable Sales_Amount is assigned a fixed value, the variable var1 is assigned a variable directory_var, and the variable var2 is assigned a reserved variable DATE.
