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 data table

One of the enumerators in Foreach Loop is the Item Enumerator. This enumerator has the ability to create a temporary table in the SSIS Foreach Loop Container itself to use as the iteration list. This option will remove the need for an external temporary storage as we saw in the Foreach Loop Container: looping through result set of a database query recipe of this chapter.

In this recipe, we will reveal another real world sample with Item Enumerator. We will loop through the list of servers with different database names, and load the same data structure from the same table but onto different servers into different excel files which will be named based on the data sources.

Getting ready

  1. For this recipe ...

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