Share via

SSIS Variables

  • Article

Variables of SQL Server Integration Services.

  • SSIS supports two types of variables; System variables and User-defined variables
    • System variables store information about a package and its objects and are automatically populated at runtime.  System variables cannot be changed by a package developer.
    • User variables are defined by package developers and can be created for all SSIS container types. 
  • Every [[articles:SSIS containers|SSIS container]] has a collection of variables scoped to it. A variable can be accessed by the container that it is scoped to and every container that is a descendent of that container in the [[articles:SSIS container hierarchy|container hierarchy]].
  • Note that the [[articles:SSIS container hierarchy|container hierarchy]] can extend over multiple packages when the [[Execute Package Task (SSIS)|Execute Package Task]] is being employed, and hence a package called from the [[Execute Package Task (SSIS)|Execute Package Task]] can access variables scoped to [[articles:SSIS containers|containers]] within the calling [[articles:SSIS package|package]].