Post reply

SSIS - Access to the path is denied

  • March 18, 2010 at 1:30 am

    #216684

    [font="Verdana"]Hi All,

    I have one SSIS package in which I have one task, i.e. Execute SQL Task with SQLSourceType = File Connection inside For Each Loop container. In the path specified for File Connection's property of Execute SQL Task, I have some DDL scripts. When I run the package, it throws Access to the path {folder path} is denied. error.

    Can anybody explain, being an Administrator why such error is occuring?

    Thanks in advance,

    Mahesh

    [/font]

    MH-09-AM-8694

  • April 8, 2010 at 9:23 am

    #1148387

    did you ever manage to find out what the problem was i am having the same problem.

  • April 8, 2010 at 9:57 am

    #1148421

    What permissions is SSIS running under? Does it have rights to the file?

  • April 8, 2010 at 9:59 am

    #1148422

    well as far as i know it runs under my name when im running it on my local in bids and its always worked before.

  • April 8, 2010 at 10:37 am

    #1148468

    Is there any additional detail in the Execution Results tab?

  • April 9, 2010 at 12:19 am

    #1148837

    nope unfortunately thats all it says

  • May 14, 2010 at 7:16 am

    #1167514

    the problem seems to be absolute path on different machines....

    when you have a package on BIDS on your machine and you reference a file like c:\somfile everything works ok...

    When you deploy the package and try to execute it from for example sql server using tsql or something, then the package gets executed on the remote machine

    so c:\somefile doesnot have any meaning ....

    it is a good idea in general to use network shares as file repositories

  • May 14, 2010 at 9:11 am

    #1167617

    I believe when you use the execute SQL task like that is uses the permissions of the service running SQL server for authentication. Does the SQL server users have authority to the path in question. I do not think your authority matters.

  • May 4, 2011 at 6:44 pm

    #1320171

    I am having the same problem.

    System.UnauthorizedAccessException: Access to the path is denied.

    How to enable SQLServer to access local drives on server?

    Thanks,

    Kamran

  • May 4, 2011 at 11:46 pm

    #1320213

    talha kamran (5/4/2011)

    I am having the same problem.

    System.UnauthorizedAccessException: Access to the path is denied.

    How to enable SQLServer to access local drives on server?

    Thanks,

    Kamran

    The SQLServer service runs under a specific account. You can check it in the configuration manager. You need to give this account the necessary permissions to the folders.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 6, 2011 at 7:09 am

    #1320982

    You may need to create a proxy account & have the SSIS run under that account. The proxy account would need permission to access the particular folders / files.

  • December 12, 2014 at 11:08 am

    #1764534

    I was having the same issue. Solution was to right click Data Tools and "Run as administrator". That solved the problem. Raphael

  • February 2, 2015 at 9:06 pm

    #1774928

    windows has its limit of 256 characters that's why we encounter errors like this. Long Path Tool is an easy fix for this situation.

Viewing 13 posts - 1 through 12 (of 12 total)

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