Can you pls check the web user is a part of MSDB database. And it's cumbersome to create a user in MSDB for each of the web user.

Since you call the dts package from the procedure, I hope there's no trouble in executing the package on the dbo account.

Thanks,

Ganesh