It was interesting back to basics for me as I was working through an issue for a customer.

Thanks for the update. Good to know that checking the file first is probably a good checklist item.

It's definitely not pretty, and doesn't perform well. Learning XQuery isn't easy, either.

You may think it's easy now, Eirikur, but I suspect you're discounting your efforts in the...

Flash a-ah
He'll save every one of us

Late, but if you are running this in SSIS, have you enabled logging for the package and check that? The Job logs aren't great, but if you look at SSMS...

You need XQuery to do this. You can search a series of XML documents in rows and then update then. It's not easy or pretty.

This article might help:...

Have you downloaded the Provider and installed it on the server? That is sometimes an issue.
https://www.microsoft.com/en-us/download/details.aspx?id=13255

Also, is this path the path on the server or...