In SSIS , we can have scope for the variables. Package Scope Variables. They are
System Variables:
It is predefined and Read only. These variables maintains package execution related information. It present in "System" namespace.
Usage: System variables information can be populated into audit tables used for monitoring packages.
User variables: User variables are defined by the user. It can be read and write . It presented in "User" namespace.
Usage: These variables can pass information from one execution to other executables[ generally properties].
Dynamic behavior can be implemented for executables through variables.
Syntax:
Namespce : : Variablename
System : : Package name
U, ser : : constr
User : : File Path
Expressions in SSIS:
- System Variables
- user Variables
System Variables:
It is predefined and Read only. These variables maintains package execution related information. It present in "System" namespace.
Usage: System variables information can be populated into audit tables used for monitoring packages.
User variables: User variables are defined by the user. It can be read and write . It presented in "User" namespace.
Usage: These variables can pass information from one execution to other executables[ generally properties].
Dynamic behavior can be implemented for executables through variables.
Syntax:
Namespce : : Variablename
System : : Package name
U, ser : : constr
User : : File Path
Expressions in SSIS:
Used to implement dynamic behavior for executables. Expressions can be prepared by using System variables, User Variables, Operators, built in functions scripting. Expressions can be with any executable properties like variables. Expressions are case sensitive.
Syntax: @ [Namespace : : UserName]
Example : @[User : : Filepath]
No comments :
Post a Comment