WiseOwl Training - Established 1992
To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.32 out of 10, based on 8628 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

A detailed blog exploring what's new in SSIS 2012
Part eight of a eleven-part series of blogs

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!

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

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.

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