I am having a console application, having an exe and couple of dll's
We are using an SSIS package to invoke this exe and inturn the package is scheduled on a sql job which uses a proxy user which is domain user
The exe's and dll's are located on a remote location not on the dbserver.
We were getting exceptions for accessing one of the dll's from exe when we executed like as a job.
The workaround I got is to add a code group for the remote network path and also to add onto trusted sites for the group policy on the active directory on domain controller.
It would be great if someone can suggest any better option.
...
Go to the complete details ...