I made an example for those people that still need:

http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx

I hope this help.

regards,

Pedro

http://www.pedrocgd.blogspot.com