What error messages do you get out of SQL Agent?
Have you set up logging in the SSIS package and examined its output?
Those two should give you a good clue as to what is going wrong.
HTH
=====
Todd C
"jdm_222" wrote:
Quote:
Hello,
I am trying to run an SSIS job that has to access some EFS protected
directories. If I run the package directly as the user that owns the EFS
protected directories it runs with no problems.
I set up a credential and proxy to run the SSIS job as the same user but it
bombs out when it attempts to access the EFS directories even though I am
running under the context of the user that can access them. Am I running
into some funky delgation/impersonation issues related to EFS?
Thank you,
|