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

Foreach Loop Container: looping through result set of a database query

Foreach Loop Container is one of the two loop structures in the SSIS Control Flow, and it can be said strongly that this is the most useful. The Foreach Loop provides a method of looping through seven different types of enumerators and can loop through different types of collections. Collection types vary from files in a folder to nodes in xml data or records in a database table.

In this recipe, we will take a closer look at the ADO enumerator and one of the most useful real world scenarios of using this container.

Suppose that we want to loop through different SQL Server database servers, each server having a different server name and different database name. We read list of ...

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