which service account? UNC path

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

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


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

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