A detailed blog exploring what's new in SSIS 2012
Part four of a -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 3 - Choosing Tasks from the SSIS Toolbox

The SSIS 2008 R2 toolbox is simple - control flow tasks are shown in alphabetical order, and data flow tasks are divided into source, transform and destination components.  By contrast SSIS 2012 tasks are categorised:

2008 R2 data flow tasks 2012 data flow tasks
2008 R2 data flow tasks 2012 data flow tasks

In general, the assistants and categorisation in 2012 make tasks easier to find (ITOO - In This Owl's Opinion).

Lest you be thinking by now that all of the changes in 2012 are cosmetic, let's look at a functional one - shared data connections.

This blog has 0 threads Add post