WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
A detailed blog exploring what's new in SSIS 2012
Part five of a eleven-part series of blogs

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:

2008 R2 connection manager

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:

2012 connection manager

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.

This blog has 0 threads Add post