Pro Programmer: Variables/Variable Scope

Tuesday, August 14, 2012

Variables/Variable Scope

Variables store values that a SSIS Package and its containers, task, and event handlers can use at run time. SSIS supports two types of variables :
  • User-defined Variables are defined by the package developers (or users). You can create many user-defined variables for a package.
  • System Defined Variables are defined by SSIS.
Variable Scope: A variable is created within the scope of a package or the scope of a container, task or event handler in the package. Default variable is created at package scope but can be scoped to different levels within a package.



No comments:

Post a Comment