Can you please post the table ddl and sample data?
😎

Don't think you can supress this message, do you have VSS (Volume Shadowcopy Service) on the DB volumes?
😎

Something like this maybe?
😎

SELECT
  PROP.DATA.value('(@Name)[1]','VARCHAR(100)')
FROM @DTSXML.nodes('//Property') AS PROP(DATA)

You will have to add either the namespace declaration or a namespace wildcard...

My guess is that the application / package renames the actual backup to DoNotDeleteThisFile.txt
😎

I have seen this before, IIRC, I bounced the Full Text Services with "net stop xxx" and "net start xxx" to resolve it.
😎

You might want to...