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

[arunaramana]

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

Here is the link for Microsoft documentation from which the above highlighted text is taken:

https://docs.microsoft.com/en-us/sq.../foreach-loop-container?view=sql-server-ver15

Would anyone please help me understand the context? Thank you for giving your valuable time.

 

[Igelchen]

Hello,

for example you can create within a script task a List<string>.

You can save this List into a variable of type object.

Then you create a variable of type string.

Then you can walk through this List within the "Foreach Loop Container".

Here is an example well explained:

https://stackoverflow.com/questions/3674364/how-to-use-list-collection-for-foreach-in-ssis

Best Regards