I have recently been demonstrating SQL Sever Integration Services (SSIS) to a number of people and there seems to be some confusion on how the (SSIS) For Each Container can be used to to perform an operation on a collection. Rather than trying to document how to use the SSIS For Each Container I have used Camtasia Studio (http://www.techsmith.com/camtasia.asp) to record the use of the For Each Container to load all files in a specified directory. The movie file illustrating the SSIS For Each Container can be downloaded from https://www.wardyit.com/video/SSISForEachContainer.wmv.
