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
