Discussion:
EFS problem with SSIS Job
(too old to reply)
jdm_222
2009-11-03 14:47:01 UTC
Permalink
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,
Todd C
2009-11-03 21:54:02 UTC
Permalink
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
Post by jdm_222
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,
Loading...