O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Shared connection managers

If you have experience of developing SSIS packages, this is one new feature we think you are really going to like. When creating a package, Integration Services has a wide number of connection managers available to enable you to connect to data sources from SQL Server and Analysis Services, to Excel and CSV, as well as FTP, HTTP and more.

A new feature in Integration Services 2012 is the ability to share a connection across multiple packages within your project. Let us take a look at how this works. Open SQL Server Data Tools (SSDT) and create a new SSIS project. This will utomatically add a new package:

  1. In the Solution Explorer pane right-click on the Connection Managers folder.
  2. Choose on New Connection Manager.This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required