Continuing from my last post on variable basics ,you can click here to view MSBI # 10 – SSIS # 3–Familiar with SSIS Variables from 0 to Expert (Part–I-Introduction) « (B)usiness (I)ntelligence Mentalist
What is System Variable in SSIS
In SSIS we already have set of system variable which we can directly use in our development We can select it as shown in Variable plane
SQL Server Integration Services provides a set of system variables that store information about the running package and its objects. These variables can be used in expressions and property expressions to customize packages, containers, tasks, and event handlers
Explanation of each System variable as shown
We can find more details regarding System variable on MSDN website
Example of above System variable are
Please ignore MyFirstVar its User Defined Variable
For more Details regarding System variable click on follwing image and jump into MSDN Website
We will have few more focus on SSIS Variable in upcoming post
If you wan more interesting link please visit our link resource website