WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 516 reviews for our classroom and online training
A detailed blog exploring what's new in SSIS 2012
Part eight 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 7 - Easier to use Data Viewers

When you want to know what's going down a path, you can set a data viewer:

Setting a data viewer

Setting a data viewer in SSIS 2008 R2 (the 2012 option is similar).


In 2008 R2 you can do all sorts of things with data viewers:

Data viewer dialog box

Histogram, anyone?

Microsoft have bravely removed most of this functionality, with the result that a data viewer can be created with a single mouse-click:

Data viewer in 2012

In 2012 you create a data viewer without having to confirm how it will work.


This is an example of good software - keep it simple! 

Perhaps a bit late in the day (or at least, the blog) it's time now to look at perhaps the biggest difference in SSIS 2012: deployment.

This blog has 0 threads Add post