Thanks. It helps me to resolve my issue soon.

Robert,

Thanks a lot for sharing the code.  It works for me after I replacing the following assignment statement in the code:

from: set @mpath='Backup File Path' + @dir + '\' +...