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.

    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.

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

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