Post reply

SQL agent job fails when accessing the csv file

  • June 17, 2013 at 2:09 am

    #295360

    Hi All,

    I have a csv file in a shared folder in a server. My package is running fine in the designer, but when I set up a sql agent job for the package, it throws the below error:

    ---"System.Unauthorizedaccessexception: access to the path "\\sharedfolderserver\sharedfoldername is denied"--.

    I know this is some where related to securtiy issue.COuld anyone pls help on this? Thanks!

  • June 17, 2013 at 11:55 pm

    #1624865

    Please check whether SQL Server Agent Account/account with which package is executing has access to path "\\sharedfolderserver\sharedfoldername". In your designed, SSIS package runs with your own user account however when you deploy it to SQL Server, it will run with SQL Server Agent Account so that account should have access to requested path.

    Regards,

    Sacheen

    :rolleyes:

  • June 19, 2013 at 2:25 am

    #1625316

    Thanks for your reply,

    Yes the account under which the sql agent jobs runs also has permissions to the shared folder. but the job is still failing. Any help?

    Thanks!

  • June 19, 2013 at 4:13 am

    #1625360

    var05 (6/19/2013)

    Thanks for your reply,

    Yes the account under which the sql agent jobs runs also has permissions to the shared folder. but the job is still failing. Any help?

    Thanks!

    Sorry to question that, but are you certain? How did you determine the SQL Agent account?

    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

  • June 19, 2013 at 7:58 am

    #1625480

    Thanks for your reply.

    We have a user under which all the sql jobs are executed. And I assume that particular sql account needs to have access to the shared folder?

    Could you please let me know if I am right?

    Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

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