WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
A detailed blog exploring what's new in SSIS 2012
Part two of a eleven-part series of blogs

Posted by Andy Brown on 27 November 2014

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 1 - SSIS 2012 Looks Different!

I've created two functionally identical packages in SSIS 2008 R2 and SSIS 2012.  Here's what they look like when you run them (the last task is in progress in each case):

SSIS 2008 R2 look and feel SSIS 2012 look and feel
SSIS 2008 R2 SSIS 2012

Although it make absolutely no difference to what packages do, SSIS 2012 looks better and for some reason is much more rewarding when packages work successfully!

In addition to the cosmetic differences above, SSIS 2012 also allows you to zoom in and out:

Slider in SSIS 2012

This feature isn't available in the earlier version of Integration Services.


Staying with cosmetic differences, let's now take a look at variables in SSIS 2008 and 2012. 

This blog has 0 threads Add post