• However, when the user tried to execute package, she says it gives her an error.

    How is this person trying to execute the package? Have you tried right-clicking on the package in the MSDB directory on the production server?