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 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 container hierarchy.
  • Note that the container hierarchy can extend over multiple packages when the Execute Package Task is being employed, and hence a package called from the Execute Package Task can access variables scoped to containers within the calling package.