Variables
in SSIS:
System Variables
|
User Defined Variables
|
1 To
hold system info
|
1 To
hold User Given data
& created by user only
|
2 Pre
Defined
|
2 User
Defined
|
3 READ
Only
|
3 READ
& WRITE
|
4 Stored
under
System
:: <Name Space>
|
4 Stored
under
USER
:: <Name Space>
|
Usage:
used for Monitoring the packages
|
Usage :
to implement Dynamic behavior for executable we use User Defined Variables
|
Variable Scopes: 1. Package Level 2. Task Level
No comments:
Post a Comment