none
Failed to open package file due to error 0x80070005 "Access is denied.".

    Question

  • I have custom .Net web application. I would like to run SSIS packages via web page clicking run button. 
    -Windows Server 2008R2 64bit.
    -.Net framework 4.0
    -Visual Studio 2010
    -SQL Server 2008R2/2012
    -IIS

    I have following sample code here:Yes I'm using "Using a Web Service or Remote Component to Run a Remote Package Programmatically" http://msdn.microsoft.com/en-us/library/ms403355.aspx

    I tried the example code, but could not open the package.
    When I click the dtsx file, I can succesfully execute it and I see that file path \\SRV27\c$\SSIS\Test1.dtsx is correct.
    Is this related to permissions? I have already tried to give file permissions to application pool identity and SQL Server Agent, but no effects.
    The SQL Server locates in the SRV22 and my web application in SRV27.


    What should I do?

    ERROR in the browser--------------------------------------------------------------
    Package load did not succeed, error: Failed to open package file
    "\\SRV27\c$\SSIS\Test1.dtsx" due to error 0x80070005 "Access is
    denied.". This happens when loading a package and the file cannot be opened or
    loaded correctly into the XML document. This can be the result of either
    providing an incorrect file name was specified when calling LoadPackage or the
    XML file was specified and has an incorrect format.

    --------------------------------------------------------------------------------


    Kenny_I


    • Edited by Kenny_I Tuesday, October 09, 2012 6:31 AM
    Monday, October 08, 2012 12:11 PM

Answers

All replies

  • Hello,

    Did you try to manually create an Agent SQL job and execute it? It seems like the credentials that executes the job has not permissions to open the package location.


    Víctor M. Sánchez García (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

    Monday, October 08, 2012 12:28 PM
  • I have not created Agent SQL job. The front-end(SRV27) server have only SSIS and Tools installed. I was just checking if account that runs SQL Agent in SQL Server 2012(SRV22) needs user rights to the folder where SSIS is locating (SRV27). It did not affect to my problem. Please advice me if you know how to move forward.


    Kenny_I

    Monday, October 08, 2012 12:55 PM
  • Ok, then here SQL Agent doesn't take in play, but code wich you refers to is for executing an existing job so I'm missing something. Maybe you mean the second piece of code? (Using a Web Service or Remote Component to Run a Remote Package Programmatically)

    If yes, maybe the problem is that credentials are not being impersonated and the application's user  does not have permissions on target


    Víctor M. Sánchez García (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

    Monday, October 08, 2012 10:59 PM
  • Problem was related to the dollar mark which requires admin rights. I modified to the path format and now it works.

    "\\SRV27\c$\SSIS\Test1.dtsx"

    • Edited by Kenny_I Tuesday, October 09, 2012 10:53 AM
    • Marked as answer by Kenny_I Tuesday, October 09, 2012 10:54 AM
    Tuesday, October 09, 2012 6:48 AM