Feb 7, 2013

SSIS - Foreach Loop Enumerators

A lot of times while taking interview I feel that most people know of 2 enumerators used in Foreach Loop Container and they are “Foreach File Enumerator” and “Foreach ADO Enumerator”
So lets talk about the enumerators available in SSIS. Unless we know them we will not be able to implement them right?

What are the different types of enumerators available in SSIS Foreach Loop Container?
  1. Foreach File Enumerator
  2. Foreach Item Enumerator
  3. Foreach ADO Enumerator
  4. Foreach ADO.NET Schema Rowset Enumerator
  5. Foreach From Variable Enumerator
  6. Foreach NodeList Enumerator
  7. Foreach SMO Enumerator