SSIS pacckages contains a script, that checks, whether directory exists. Directory.Exists() method returns false, but I have an access for the folder as Administrator. How could I determine, what user permissions are used during SSIS packages execution.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
It depends how you are running it. From BIDS, it's the user running it, from SQL Agent it's generally the SQL Agent account. From a stored procedure it's generally the SQL Server account.
To find out for sure, monitor the DTEXEC process using ProcMon
回答2:
In addition to the comments from @ElectricLlama, you can also execute a SSIS package in the context of a different set of credentials via a proxy account.
