• Scott, did you ever get a solution to this somewhere? 
    I was very curious on your post, I am new to the forum and had some XML trouble too.  Given that so many people have given me the impression that XML is the best thing since sliced bread and any competent SQL server developer simply must know it, I assumed the forum would burst with joyful rivers of advice, but rather I don't quite get that feel (other than "don't use SSIS for XML related tasks", and it seems your question got zero responses, unless my newness to the forum is impacting my ability to see replies.......

    For me everything is working "ok" on the import, except values in ID attributes aren't coming through correctly.  They're spontaneously generating other whole number values rather than the "1" and "2" values I see in the XML file, which I would depend on to join the data which is going into, (of course), a different sql table per-"layer" of XML elements.

    (I normally wouldn't muddle up a forum by poking around for additional help on other people's questions, but since there's little activity on either one, we might as well create some here!)