Enumerators in SSIS Foreach Loop
There are different types of enumerators in the SSIS Foreach Loop Container which helps to implement different loop scenarios. In this chapter these different types explained with few case studies, with resort of these different types of enumerators , SSIS Developers can loop through specific files, or through rows of a data table, or items of an array or other kinds of list structures. Variaty of these types will reduce needs of scripting.
In this article these types of enumerators considered:
File Enumerator, Item Enumerator, ADO Enumerator, ADO.NET Schema Rowset Enumerator, From Variable Enumerator, NodeList Enumerator, SMO Enumerator.
This session is based on the book chapter of SQL Server MVP Deep Dive 2