What user permissions are used by SSIS during exec

2019-08-24 15:54发布

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.

2条回答
我欲成王,谁敢阻挡
2楼-- · 2019-08-24 16:12

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

查看更多
Lonely孤独者°
3楼-- · 2019-08-24 16:15

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.

查看更多
登录 后发表回答