Hi @Srinivas K ,
In this scenario, it can't find file when executing package via job, you need to give the permission under that file path for your proxy account.
running-a-ssis-package-from-sql-server-agent-using-a-proxy-account
Since you can execute package successfully in SSDT, you can consider change the services account of Agent Job to your current user and try again.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.