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.
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
