Hi @Taariq Toffar ,
1.According to the details error, it seems that the user who to execute ssis package in job does not have full permission to access to the excel file.
Please check if you run packages in job and open or use the excel files in other progress at the same time.
2.Please create a proxy that has the required permissions to the excel file.
A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step.
Please refer to Create a SQL Server Agent Proxy.
Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.