gregg_dn (1/3/2011)

---

I'm getting an the following error when I try to run the OPENROWSET function:

DECLARE @CD TABLE (XMLData XML);
INSERT INTO @CD
SELECT *
FROM OPENROWSET(BULK N'C:\SQL\cd_catalog.xml', SINGLE_BlOB)

Msg 491, Level 16, State 1, Line 5
A correlation name must be specified for the bulk rowset in the from clause.

Is there something in the code beyond SINGLE_BLOB) ?
Thanks
G. Daniels

Kelsey Thornton (1/3/2011)

---

Thanks for this.
It's now clearer.

paul.marsh (1/3/2011)

---

decent article - good reference. but I feel a comment about the bcp utility should be added for those situations that warrant a different approach.

shad-873858 (1/3/2011)

---

Yes, as the author noted, you have to provide an alias to the OpenRowset. In his example the author used rs. This will get you past that particular error. Good luck.

Jeff Moden (1/3/2011)

---

I have to admit, I've not yet had to enter the realm of loading XML files. But now I know where to go for a quick reference. Thanks for filling in the cracks on this one, Wayne!

Steve Jones - SSC Editor (1/3/2011)

---

Excellent discussion, Wayne. This is one that I will keep bookmarked.

mtillman-921105 (1/3/2011)

---

Excellent Wayne, thank you sir!

gregg_dn (1/3/2011)

---

Thanks!

Geoff A (1/3/2011)

---

This is great info. Thanks Wayne.

what do you think about making ALL x.data.values to be VARCHAR in the event that the XML is not well formatted?