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 (this blog)
- 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
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 between Integration Services 2008 R2 and 2012
What's new in SSIS 2012? Superficially, lots, but when you look behind the scenes there aren't actually too many changes (this blog lists my personal top 10).
This blog is aimed at users of SSIS (and managers of SSIS staff) rather than database administrators. A quick summary for the time-constrained: SSIS 2012 is fundamentally the same as 2008 R2 in use, but the way in which you deploy packages has changed radically.
So let's get started by looking at the single biggest reason to upgrade: the green ticks and red crosses!
- Differences between Integration Services 2008 R2 and 2012 (this blog)
- 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