Ask a question about Execute Process Task

Question

Hi guys:

I use one Execute Process Task to execute my Excel automation C# application, but my automation application can't access the specified folder. I run the SSIS package under specify proxy(the corresponding user has administrative right on that computer). It is strange, please give me some advice to fix this issue.

Thanks in advance!

---

Best regards,
Riquel

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 1

Any errors?

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 2

Sure, thanks for your asking. That is one .NET automation application. When I run in VS2010 designer, it runs well. In SQL job, I got the information: can't find the file. Any way, the Excel don't open the file to execute my code.

Please let me know whether this is adequate to get some help. thanks

---

Best regards,
Riquel

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

I would double check permissions. Do you use any configurations?

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 4

I don't use any configuration.

I run this package in my local computer under VS2010, it works well. 

Then create one SQL job in local SQL server to run this package. Finally this automation application throwes the exception because it can't open the file.

Please let me know whether you can give me some other advice. Thanks!

---

Best regards,
Riquel

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 5

Hi Riquel,

Running packages via SQL Agent often ends up with permission issues. You mentioned you created a specific SSIS proxy. Can you confirm that it is used to execute the job? Otherwise it's run by the Agent service account and that might not have access to the required folder.

I assume you created a credential too, that uses the corresponding admin user's login.

If you really using the SSIS proxy and it's just your local machine I'd suggest turning back to SQL Agent service account and give him access to the folder.

Let me know if you can solve this but I agree with Koen that it is most likely a permission problem.

Answer 6

thanks Martin for this information. I will double check the security setting again. Then let your know whether I have fixed this issue or need further kind help from your guys.

Have a nice day!

---

Best regards,
Riquel

Please remember to mark the replies as answers if they help and unmark them if they provide no help.