Home Forums Data Warehousing Integration Services which service account? UNC path RE: which service account? UNC path

  • August 25, 2016 at 6:20 am

    #1897449

    inevercheckthis2002 (8/25/2016)

    The goal is to have an SSIS package run from a SQL Server Agent job access an Excel spreadsheet over a UNC path.

    Which credential will need permission to read from the UNC path?

    - the service account running SQL Server Agent?

    - the service account running SQL Server Integration Services?

    Thanks.

    SQL Server Agent.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.