Microsoft SQL Server – export XML column rows from SQL table into individual files
It is roughly formatted as such
+————–+——————+
| REFERENCE_ID | REFERENCE_XML |
+————–+——————+
| 1 | <xml>…</xml> |
| 2 | <xml>…</xml> |
| 3 | <xml>…</xml> |
| 4 | <xml>…</xml> |
| … | <xml>…</xml> |
| 70000 | <xml>…</xml> |
+————–+——————+
I would like to loop through every row and bulk export each REFERENCE_XML column and name it as the REFERENCE_ID
My output folder set would look as such