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

image_thumb13

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

image 

We can find more details regarding System variable on MSDN website

Example of above System variable are

image

Please ignore MyFirstVar its User Defined Variable

For more Details regarding System variable click on follwing image and jump into MSDN Website

image 

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: