Roger Doherty, whom I have previously heard of through Conchango's involvement on the Ascend programme, has had some experience of using the XML Source Adapter and has written about it here. Worth reading if you intend using the XML Source Adapter at any stage.
Roger says he plans to write a series of blogs about a mini-BI implementation that he is doing so it could make for interesting reading. I for one will be keeping his blog on my aggregator.
For those that don't know, the XML Source Adapter enables you take an XML document and treat it as a source of rowset data. The data can then be used in an SSIS data-flow as if it had come from a flat file or a RDBMS.
-Jamie