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
-- Brian Knight