Calculated variables pass the results of a formula into a source query or to other formulas.
A calculated variable is evaluated as each source row is processed. The result is then passed to the source query or to other formulas used in the job that reference the variable name. This saves processing time compared with having the same formula evaluated multiple times.
The formulas for calculated variables are stored within the DTS file.
| Note: |
|