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
- Difference 8 - Deploying Packages in 2012
- Difference 9 - Parameters and Environments
- 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:

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):

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!
- 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
- Difference 8 - Deploying Packages in 2012
- Difference 9 - Parameters and Environments
- Differences 10 - Other Miscellaneous Changes (this blog)