Chapter 4. New SSIS Designer Features

The Integration Services Designer

Visual Studio

The first thing you’ll notice when starting a new SSIS project in SQL Server 2012 is that SQL Server Data Tools (formerly Business Intelligence Development Studio) has been upgraded to Microsoft Visual Studio 2010 SP1. Along with the upgrade comes an updated look and feel (shown in Figure 4-1): You’ll find many small visual improvements, such as an updated color scheme, new icons, and rounded corners on the tasks and transforms.

Figure 4-1. The SQL Server 2012 designer for Integration Services.


Changes were ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.