Bulk copy XML data to SQL data source

Can anyone provide an expample of bulk copying XML data to a SQL table. I am also looking at using column mapping so that I can map fields and also insert a new GUID into the key of the SQL table.

Many thanks

There are some ways, take a look at this link:

Importing Bulk Data by Using BULK INSERT or OPENROWSET(BULK...): http://msdn2.microsoft.com/en-us/library/ms175915.aspx

And examples for bulking XML data can be found here:

http://msdn2.microsoft.com/en-us/library/ms191184.aspx