Here is what I've learned so far, and a review of what I wish to
accomplish.

First off what I want to accomplish: Import the SDN (Special Designated
Names) List from:
http://www.treas.gov/offices/enforcement/ofac/sdn/sdn.xml to SQL
Server. Preferrably 'as is' without having to modify the file at all.

The U.S. Treasury makes the xml file and an xsd file avialble also
here: http://www.treas.gov/offices/enforcement/ofac/sdn/index.shtml

It appears as though the xml file contains an in-line schema. Quite
obviously the xsd also provides a scheme definition. Because
SQLXMLBulkLoad *does not* support in-line schemas, I cannot use it that
functionality. I have searched exhausitively online for some clue as
how I could import this data into SQL Server as is.

Could someone *please* take a brief look at the xml & xsd, and let me
know if it's even possible to 'bulk' load this data as is, or if it has
to be copied locally first? Or what the recommendation is? I can write
DTS packages, stored procedures, vb or javascripts, including some .Net
also.

Additionally I have search Usenet, including this group, others too
have struggled with this, and this data in particular. Unfortunately
there do not appear to be any clear answers.

Thank you!