THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

Variable enhancements in RC0 [SSIS]

I have been poking around idly in the RC0 release of SQL Server Integration Services (SSIS) 2012 and noticed a few nice enhancements that hadn’t really hit the newsstands as yet (well, I didn’t know about them anyway). Here is a quick rundown:

Expression is viewable in the Variables window


Fairly self-explanatory this one. If a variable has an expression applied to it that expression can now be seen in the Variables window; also notice that the variable icon gets an adorner specifying that there is an expression upon it. What is not so obvious is that if you add an expression to a variable then the EvaluateAsExpression property of that variable is automatically set to True:


That’s a welcome enhancement.

New System Variables

There are some new System variables available to you, some of which might be useful (one of which is very useful indeed):


I have not found any documentation on these as yet so I’ll take a guess at what are for:

  • IgnoreConfigurationsOnLoad – This is a boolean variable so I can only assume it does what it says on the tin – ignores configurations. The default value is False. I would assume that this doesn’t have any affect if you are using the new project deployment model.
  • ProductVersion and LastModifiedProductVersion – In the package I am looking at these are both set to 11.0.1750.32 which is the same build number as in Help->About


The only thing I don’t understand is that if this package was built in a prior version (CTP3) why they are set to the same value?

  • ServerExecutionID – This one is very useful indeed. It provides the ExecutionID that the SSIS Catalog assigned to the current execution.


Hope that helps!


Published Wednesday, February 22, 2012 11:56 PM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Pedro perfeito said:

Dear Jamie,

The variables ProductVersion and LastModifiedProductVersion already exist in SQL 2008 R2. The new system variables are just ServerExecutionID and IgnoreConfigurationsOnLoad.


Pedro Perfeito

February 29, 2012 8:48 AM

Leave a Comment


This Blog


Privacy Statement