Foreach Item Enumerator - ForEach Loop Container - Use Case
Foreach Loop Container is one of the looping constructs available in SSIS packages. One of its enumerator options is the Foreach Item Enumerator. It enumerates through a list of items populated at design time. The list is static at execution time, i.e. you cannot load the list items dynamically from a configuration file or another source like an SQL table. It is probably due to the static nature of the item list, that this enumerator type is not used too often in packages. On the other hand, there are some scenarios where a static list can prove to be useful. For example – no need to create a database table just to pass on values for the Foreach Loop enforce a specific order to the parameters passed to the loop initialize variables values with the Item Enumerator instead of doing that in a Script task Another frequent requirement in SSIS packages is to execute a set of operations against different SQL Servers or databases. The package should change the OLE DB c...