I’d probably go about this using .net code inside an Orchestration – for insertion at least.
Otherwise, have you taken a look at: http://www.biztalkgurus.com/samples/SQL-XML-Data-BizTalk-2006.html This should be able to process any type of data, just make sure you use the pass though pipeline.