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 the information source from which I took the above lines of text: https://docs.microsoft.com/en-us/sql/integration-services/control-flow/foreach-loop-container?view=sql-server-ver15