Jason & Brian,

I will look into the following resource:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/69441/

In the meantime, what I have done in place of using a new credential is that I went back to the properties...

Jason & Brian,

Your question makes perfect sense; under what context does the SQL Agent run? Under the Network Service account. Thanks for clueing me in.

But what I don't understand is...

I don't have much say in this environment, even though I'm the only SQL guy in the IT dept. It was my Sup who decided that there should be a...

Toby

Thanks for the advice. I will apply the suggestions where I can.

Thanks