how do i know which mode it is running from? i got access denied when i tried to access the reporting service using the ssms

you can change the files under the restore as found in the options

how do i implement sql double take?

you might want to implement auditing on your SQLServer, especially if you granted a user to the db_owner. Having db_owner has all the privileges on the database including dropping...

The package can be executed using the right click menu.

the package is actually executed by means of the execute package on the right click menu.  there is nothing on the job history and package log .