Share via

Unable to run SSIS Package from a job using SQL Server Agent Service Account

Julie Cherry 96 Reputation points
2021-02-11T18:40:31.057+00:00

I have a package that is set up on Server A, that is to go to Server B and copy a file from one folder to another.

When I execute the package as myself under SSIS, the package runs fine, no problems, moves the file.

When I set up a job to do the same thing on a schedule, I get "access to path denied" error. The job is set to use the SQL Server Agent Service account.

I went onto the folders on Server B, and ensured that every single folder has been granted Full Control for the SQL Server Agent Service account. I set up Auditing, and I can see the logon event for the SQL Server Agent Service account, then a logoff event a few seconds later. So it seems like it's going to the server and it's able to log on, with the message in the event viewer "An account was successfully logged on."

I've confirmed from the job history and the execution report that the SQL Server Agent Service account is what executed the package.

The path to the folder in the job step configuration must be correct, because I copied the settings from there when I was configuring the package to run it directly as myself. The configuration parameters are identical.

Yet, somehow I still get this "access to path denied" error. Has anybody any ideas of what else I could check or try? I've been stumped by this all day.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-12T04:14:38.937+00:00

    Hi @Julie Cherry ,

    1.Please check if the user in the job has full permissions to access to the folder.
    We can refer to Configure File System Permissions for Database Engine Access.

    2.Please try to create a new proxy in SQL Server job to execute the ssis package.
    We can refer to Running a SSIS Package from SQL Server Agent Using a Proxy Account.

    Best Regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments