O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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

Dynamic connection managers

Connections can be created at package level or project level, and in both cases these connections can be configured to change at runtime. A common scenario where a dynamic connection is required happens when a package should execute against different development or production environments. The option of doing it manually each time a connection change, can be time consuming and even more dangerous.

Getting ready

To get ready for this recipe, follow these steps:

  1. Open SQL Server Data Tools (SSDT) and create a new SSIS project.
  2. Provide a name and a location for the SSIS project and proceed.
  3. Select the package created by default and rename it to: P01_DynamicConnections.dtsx.

How to do it...

Imagine the scenario where customer data ...

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