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.
For this recipe we need to have both
AdventureWorks2012andAdventureWorksLT2012together.Create a
R05_Template.xlsxfile that only contains two column headers namely,SchemaNameandTableName.