BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
If you're wondering whether to upgrade to Integration Services 2012, or just want to know what differences there are between SSIS 2008 R2 and 2012, this blog should help you!
- Differences between Integration Services 2008 R2 and 2012
- Difference 1 - SSIS 2012 Looks Different!
- Difference 2 - How Variables are Treated in SSIS 2012
- Difference 3 - Choosing Tasks from the SSIS Toolbox
- Difference 4 - Shared Connections at Project Level
- Difference 5 - Expression Tasks in 2012
- Difference 6 - Undoing and Redoing Commands
- Difference 7 - Easier to use Data Viewers (this blog)
- Difference 8 - Deploying Packages in 2012
- Difference 9 - Parameters and Environments
- Differences 10 - Other Miscellaneous Changes
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 in SSIS 2008 R2 (the 2012 option is similar).
In 2008 R2 you can do all sorts of things with data viewers:

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:

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.
- Differences between Integration Services 2008 R2 and 2012
- Difference 1 - SSIS 2012 Looks Different!
- Difference 2 - How Variables are Treated in SSIS 2012
- Difference 3 - Choosing Tasks from the SSIS Toolbox
- Difference 4 - Shared Connections at Project Level
- Difference 5 - Expression Tasks in 2012
- Difference 6 - Undoing and Redoing Commands
- Difference 7 - Easier to use Data Viewers (this blog)
- Difference 8 - Deploying Packages in 2012
- Difference 9 - Parameters and Environments
- Differences 10 - Other Miscellaneous Changes