MSBI # 11 – SSIS # 4–Familiar with SSIS Variables from 0 to Expert (Part–II – System Variable)

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

Link Resource # 9 July 30 « Dactylonomy of Web Resource

Hope this helps !!