Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Containers and dynamic packages


You've learned about connection managers and control flow tasks in SSIS, but so far, all you've seen are static connections. There is a vital requirement for tasks and connections to be dynamically set at runtime, for example, when you get the name of the source database servers from an Excel spreadsheet. As another example, server names would be changed for development, testing, and production purposes. In this section, we will learn more about containers to learn how to loop through items of a collection, and then how to set the connection managers dynamically.