Hello, 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. Please help. Thanks, CK

Use a domain account based proxy to run the SSIS job under to access that remote share.Arthur My Blog

Thank you Arthur. What exactly is a Domain Account based proxy. I tried creating a proxy using my windows authentication. I guess that is the local account. I can run the package manually ( using execute package) but cannot run it as a job.

Follow this article to properly configure your SSIS Job: http://bidn.com/blogs/DonnyJohns/ssas/1705/sql-server-agent-proxy-accountsArthur My Blog

Hi, Sql server Services run on one service account(run--> services.msc). Please check whether that user have access to shared drive If not, provide access to that user and check it. Thanks & Regards, Naveen Naveen Kumar