Nice Article! I first started working with XML and .Net web services about 10 years ago as a developer.

These days I wear a DBA hat and just had to write a load process for several XML interfaces. Wish I had seen this first! I found SSIS to be fairly limited and clunky compared to my earlier .Net experiences.

I settled on using the XML Source. I ended up writing a schema validation and XSLT piece to make the XML palatable for the XML Source object. XML Source wasn't very flexible, and certainly wasn't as fast as a bulk load.