If you use local variables in a mapping, use them in any transformation expression in the mapping. For example, if you use a complex tax calculation throughout a mapping, you might want to write the expression once and designate it as a variable. This increases performance since the

Data Integration Service

performs the calculation only once.

Local variables are useful when used with stored procedure expressions to capture multiple return values.