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.
相关问题
- Django check user group permissions
- SQL Server Import Wizard doesn't support impor
- SQL Server 2012- Create Database permission denied
- Bulk insert from excel to sql for selective fields
- What other dependencies do I need to install in Vi
相关文章
- SSIS solution on GIT?
- Flutter - http.get fails on macos build target: Co
- unable to access '/Users/dida/.config/git/attr
- BroadcastReceiver permission for adb shell
- How can I manually fail a package in Integration S
- See complete tooltip error message for Data Flow S
- Save content of Email body in outlook to a file
- Android 6 revoked permissions checked as granted
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
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.