May 3, 2022 at 8:11 pm
Hello, I am working on a SSIS package that needs to write data to a specific directory. The package runs in my development environment. The problem is I need to request access to the specific directory I need permission but not sure what account I need to request access for. The SSIS package will run part of a Job. Do I need to request access for the Service account running SQL Jobs? Or is a local Windows account typically used in this scenario?
May 3, 2022 at 8:43 pm
The best practice would be to create and use a proxy account - then assign the job step running the SSIS package to use that proxy account. If you don't want to do that - then you would need either the account running the agent service, or the account that owns the agent job (if that account is not a sysadmin).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply