Analytics in Action

An introduction to using Variables in SSIS packages

Integration Services provides system variables and supports user-defined variables. In this post is will demonstrate user defined variables. User-defined variables can be used in many ways in SSIS: in scripts; in the expressions used by precedence constraints, the For Loop container, the Derived Column transformation, and the Conditional Split transformation; and in the property expressions that update property values. In this example I will demonstrate how user defined variables can be used in Conditional Split Transformations to apply universal data filters at multiple positions within a package.


admin

2 Responses to “An introduction to using Variables in SSIS packages”

  1. Em

    Great site. Thanks

  2. ken

    thanks many tons