what are the items in a collection that referred in foreach item type enumerator within foreach loop container1

Question

Hello There,

When I recently gone through microsoft documentation about SSIS -- Foreach Item Enumerator, following points took my attention:

**> Foreach Item enumerator to enumerate items that are collections. For example, you can enumerate the names of executables and working directories that an Execute Process task uses.

You use the Foreach Item enumerator to enumerate items in a collection.**

From the above two highlighted statements, what are such items that considered to be collection? Is there any documented source to understand the concept of 'collection' and 'its items'?
foreach-loop-container

Answer 1

Hi @ArunRaaman ,

The For Each Item Enumerator is of the Enumerator option available in Foreach Loop Container. It will use to enumerate through a list of static items declared at the For Each Container level.

Here is an example to use ForEach Item Enumerator to Create Folders for each Month by Quarter for Current Year.

Hope it could help us to understand the collection.

ssis-foreach-item-enumerator-to-create.html

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.