Now My issue was resolved once i changed the protection level of the package to encrypt with password and i gave the credentials at Set values in SQL Agent job properties and now the job runs fine with out any issues .The issue was raised as i developed on one machine and i was running the package on other machine .