You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Difference 5 - Expression Tasks in 2012

Have a look again at our two functionally identical packages, and you'll
notice a difference:

The 2008 R2 script task ...

... is replaced by an expression task

An expression task allows us to calculate an expression, usually to store
this value in a variable.

The advantage of an expression task is that you can calculate variables
without needing to create cumbersome script tasks.

Here's what the 2012 expression task looks like (in part):

The expression task allows us to set one variable equal to the
sum of two other ones!

Time now to look at what
should perhaps have been number 1 on my list: undoing and redoing commands in SSIS.