I have a small problem here.
There is an excel file located on a shared drive. Now i am trying to access this shared drive remotely from a different server. My windows authentication has the right to access that drive. However, when i try to automate this process, i.e create an SSIS package and deploy it as a job and run the job as per schedule, I am unable to access the shared drive. I assume that is because the "job" does not have the required permission to remotely access the drive. What is the solution to this problem?
I tried giving access to PRCCSQL (which is the agent used to run the jobs) on that server, but that failed.