• I use these in several stored procs. Looks like you are missing a null.

    Your code:

    EXEC @RetCode = sp_OAMethod @oFol, 'MoveFile' , @Path,@Path1

    Try adding a null.

    EXEC @RetCode = sp_OAMethod @oFol, 'MoveFile' , NULL, @Path,@Path1