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...

I'll say that I find JSON easier to read, though once it gets complex, both of them are hard formats to work with. Haivng SQL Server work with this can...

I'd say it's slightly safer as none of the meta data for the db is removed and added back. If there were some issue, you might have an issue doing...