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 (this blog)
- 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.
Difference 4 - Shared Connections at Project Level
If you want to connect to (for example) a SQL Server database in 2008 R2, you have to recreate the connection in every single package:

In SQL Server 2008 R2 each package using a connection has its own connection manager.
In 2012 you can still use package-level connection managers, but you can also create connections at project level:

Here we assume that lots of packages are going to want to use the same connection, so we've created this as a project-level connection manager.
Time to look now at a brand new task in SSIS 2012: expression tasks.
- 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 (this blog)
- 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