Variable Grid Option (Description, Expression) in SSIS Package - SSIS Tutorial

In SQL Server Integration Services 2008, whenever we need to create expression on variable, we always have to click on variable and then press F4 ( properties window) and then write expression there.The Description was available in Properties Windows but not in Variable Pane.

In SSIS 2012, We can write expressions while creating the variable and we do not have to go to properties windows. The Description can also be provided. Once expression are written and evaluated , the EvaluateAsExpression property get set to True automatically as well.

SSIS 2008
In SSIS 2008, no Description and Expression button was available



SSIS 2012 New Variable Pane
Description and Expression Tabs in SSIS Package

How to write expression on Variable by using Expression Tab in SSIS Package

2 comments:

  1. UnknownJuly 5, 2013 at 7:55 AM

    Thanks for letting us know about the changes in variable pane and difference between 2008 and 2012.

    ReplyDelete
  2. Aamir ShahzadJuly 5, 2013 at 8:47 AM

    You are welcome!

    ReplyDelete

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)