Permissions needed for SSIS Proxy account to import from Excel

Ross 1 Reputation point

I have an SSIS package that runs from an agent job and imports an Excel spreadsheet into a database.

It will run just fine 'SQL Server Agent Service Account' is selected in 'Run as' but will fail with status = 'Unexpected termination' if I select the proxy account unless the proxy account is a member of the Administrators group on the server (which I want to avoid if possible)


Row 11 = run as 'SQL Server Agent Service Account'
Row 12 = run as 'SSISProxy' (my proxy account) where SSISProxy is not a member of Administrators in lusrmgr
Row 13 = run as 'SSISProxy' where SSISProxy is a member of Administrators in lusrmgr

Any ideas where to start? I've seen it suggested the proxy account needs read/write to the appdata area of the Default user profile but I've tried this and it hasn't helped

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,074 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 21,986 Reputation points

    Hi @Ross ,

    Go to Controlpanel --> Administrative tools-->Component Services -->computers --> myComputer -->DCOM Config --> Microsoft Excel Application.

    right click to get properties dialog. Goto Security tab and customize permissions accordingly.

    In Launch and Application Permissions, select Customize, Edit. Add the user / group that access the application.

    And then use the account to run the job for a try.


    Zoe Hui

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

    0 comments No comments

  2. Ross 1 Reputation point

    Hi @ZoeHui-MSFT , thanks for your response.

    This machine does not have Excel installed, just the Microsoft Access Database Engine 2016 Redistributable (

    Is there something else I should be looking for in Component Services?