Thanks for the article.

Even though it seems very straight forward & simple , it really isnt because the XML source adapter does not always function as you would want it to.

With simple XSD's as provided in the example, it definitely is as straight forward but in real life situations, many times the XSD's are much more complicated with child elements and such.

After relentlessly trying to make it work through SSIS, I had to resort to TSQL Xquery (using OPENROWSET) which I found out about on these forums through Lutz. I believe it is much more easier and flexible.

Anyhow, good write-up.

Thanks,

Slick