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

ArunRaaman 991 Reputation points

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'?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,626 Reputation points

    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.




    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.

0 additional answers

Sort by: Most helpful