A detailed blog exploring what's new in SSIS 2012
Part eleven 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
  9. Difference 8 - Deploying Packages in 2012
  10. Difference 9 - Parameters and Environments
  11. Differences 10 - Other Miscellaneous Changes (this blog)

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.

Differences 10 - Other Miscellaneous Changes

In addition to all of the differences listed so far, here are some other improvements in SSIS 2012.

New CDC Task

There is a new task to manage Change Data Capture:

CDC task

The new Change Data Capture task in SSIS 2012.

 

I must admit I haven't yet had cause to use this, but doubtless it will change someone's life ...

Data Taps

Another fairly specialised feature allows you to tap data (think of it as like a data view whose output is preserved):

The IdentificationString property

This property of a connection between two data flow tasks is key to getting data taps to work.

Data taps are another feature I haven't yet made us of, but there's a pretty good run-through here.

Conclusion

That completes this run-through of the main differences between SSIS 2008 R2 and 2012.  Wise Owl currently train by default on SSIS 2012, but we can arrange onsite courses in 2008 R2 and even 2005.  Just ask!

  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
  9. Difference 8 - Deploying Packages in 2012
  10. Difference 9 - Parameters and Environments
  11. Differences 10 - Other Miscellaneous Changes (this blog)
This blog has 0 threads Add post