Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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]].