dbTalk Databases Forums  

EFS problem with SSIS Job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss EFS problem with SSIS Job in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jdm_222
 
Posts: n/a

Default EFS problem with SSIS Job - 11-03-2009 , 08:47 AM






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,

Reply With Quote
  #2  
Old   
Todd C
 
Posts: n/a

Default RE: EFS problem with SSIS Job - 11-03-2009 , 03:54 PM






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,

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.