How to make the ForEach Loop Container work - the project on pp 116-117

First, you need to change the path for the 3 excel files from c:\users\Administrator\... to wherever you actually store the files (e.g., c:\user\yourname\...) in both the ForEach container and the Excel Connection Manager properties (including Excel Source if necessary). Then, for the archive Connection Manager, you can create a folder. Finally, for the File System Task, you should use 'Copy File' for Operation and 'Archive' for 'DestinationConnection'. In this way, all of the 3 files are looped.

Update:

The previous approach does not use the property expression to update the Excel Connection Manager dynamically. If using the property expression as that on p. 117, the Excel Source component in the Data Flow tab will have an error icon for invalid connection (OLE DB Error), just ignore it as the DelayValidation property for the Foreach Loop container is set to True.

More updates on the project (5/15/2011):

1. To run 32-bit in 64-bit SSIS: Project-->xxx Project Properties-->Debugging-->run 64-bit FALSE
2. many warning and error messages related to SSIS Logging and Package Configurations (as I use 2008R2 not 2008). Need to fix them as well.
3. The project basically moves 3 excel files from the location specified in the LoopEach container to the location specified in the Archive connection manager (using copy not move)
4. The definition of the User Variable [User:FileName] may need to be changed well for a valid path.