For package execution:

Can you try adding the user to db_dtsadmin ,db_dtsltduser, db_dtsoperator roles in the msdb database in sql server.

Also can you check whether the sql authenticated user has access to the DB.

open SSMS and try to connect using sql authenticated user on that DB.

Regards

Satyen