I've started to write a new series called SSIS Stumpers. Each stumper gives you an intermediate to expert-level business problem to solve with SSIS. Sample data is provided and you're asked to load the data in a challenging way or performance tune a package. Each stumper gives you the requirements at first and you can start there or turn the page to see some hints. If that's not good enough, you can see a step-by-step instruction on the next page.
The first one in the series, your given an example where you'll need to unpivot data using canned components in SSIS. You can download this SSIS Stumper magazine for free with all the data and complete project at
http://www.endtoendtraining.com/private/misc/downloads.aspx. If you'd like a step-by-step video on how to solve the problem, see my video here:
http://www.jumpstarttv.com/Media.aspx?vid=268