What user permissions are used by SSIS during execution of packages? -
ssis pacckages contains script, checks, whether directory exists. directory.exists() method returns false, have access folder administrator. how determine, user permissions used during ssis packages execution.
it depends how running it. bids, it's user running it, sql agent it's sql agent account. stored procedure it's sql server account.
to find out sure, monitor dtexec process using procmon
Comments
Post a Comment