Sql server agent job to execute a ssis package without a proxy account

Question

I created a SSIS package that extracts data from a table in server 1 and load data into a text file in a folder in server 2(not in the same domain). My windows account has access to this shared folder in the other domain. Then I created a SQL server agent job. In the job step properties tab, type was selected as SQL Server integration service package. Package source was selected as file system. If I execute the package under SQL server agent service account, I get an error saying I need a proxy account. So I created a proxy account using my windows credentials. Now it runs fine. I tested this on development server. However, my manager does not want to implement this (proxy account method) on production server, as it uses my windows credentials. Is there another way to do this? If so, can you please help me. Thanks

Answer 1

Hi @Nishan Ratna,

If you want to run the package via agent job, you must use one account which have access to the shared folder.

So you may give another account which has the permission as the proxy account or run the job with that account.

You may also check here which talked about Security best practices for SSIS package execution via SQL Agent job.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Is there another way to do this?

Change your manager to a different mind, or grant the required permission to the SQL Server-Agent service account.