Post reply

which service account? UNC path

  • August 25, 2016 at 6:05 am

    #312524

    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.

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply