Hey Satish,

On the job history, click on the expand (+) button, and look at the history for the specific step.

Looking at the history for the job isnt going to give you much, the actual reason for failure is more likely to reside at a step level.

The first thing I would ask is if my SQL server agent has the correct access required by the package.

~PD