I think I myself found the reason. I need to change the transaction isolation of the package to 'read uncommitted'.

But another question is the SP having Merge statement is...

SQL Server native backup always better than VM backups. I have even seen VM backup getting corrupted while SQL Server backup with compression going on.