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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close