thanks for your response John,

Here I am not comparing it with my login and service account.

just to narrow down the issue I logged into the server as service account using service account credentials and then ran the package execute utility and it wen fine.

then I ran the same package as Agent job and then it failing 🙁 -- While running as Agent Job it will be executed under the same service account security context.

any idea?