Most likely this is of course down to security. Running the job in BIDS is done using your credentials, but under the service account that runs the SQL Agent, it probably does not have the same rights.

What error are you getting? Have you got any logging setup and any error message in particular showing there which will point you in any one direction?