Unable to load SSIS package

  • Hi Expert,

    I am trying to upload Excel file through SSIS package , there is no job . we are calling from front-end and manually uploading. For that one we have created procedure. But while uploading package I am getting below error:

    " Description: Failed to open package file "\\testapp01\T$\SSIS_Project_Report\SSIS_Project_test\Package20.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."

    I could not get what is that error. Could anyone please help me on this.

    Thanks in advance.

    Arooj

  • arooj300 (6/25/2015)


    Hi Expert,

    I am trying to upload Excel file through SSIS package , there is no job . we are calling from front-end and manually uploading. For that one we have created procedure. But while uploading package I am getting below error:

    " Description: Failed to open package file "\\testapp01\T$\SSIS_Project_Report\SSIS_Project_test\Package20.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."

    I could not get what is that error. Could anyone please help me on this.

    Thanks in advance.

    Arooj

    What does your proc actually do? What do you mean by 'uploading' the package? Why would you upload it anywhere?

    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

  • Hi Phil,

    What does your proc actually do?

    " Actually it is already built procedure. In that procedure we have written script it will serach the folder path where all excel file is residing and upload into the application.And inside the procedure we calling xp_cmdshell login which will help to execute SSIS package.We have one application that will upload manualy all the Excel file which end users are getting from clients will upload into the application and with the help of this records they will satart doing their work"

    What do you mean by 'uploading' the package?

    Uplaoding means We are uploading excel file but before that we have to enable command shell login (xp_cmdshell) and enable msdtc service that we will give grant access to end user so that they can able to upload Excel file into the application."

    Why would you upload it anywhere?

    I hope, I have already covered this also in above points.

    Thanks

  • Are you able to execute package from BIDS ?

    If you are able to execute in BIDS, it would be permission issue for user to the path where your package is deployed.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

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

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