XML Source : Access to the path is denied error

  • Hello,

    I am trying the load the XML file to the database and I followed the below steps to achieve the task.

    1. In data flow task, i used XML source component as a Source.

    2. OLE DB as a destination.

    I used variable filepath and the value is "C:\Temp".

    In XML Source i selected "XML file from Variable" and assigned the variable filepath. I am getting an error as "The XML Source component was unable to read the XML data. Access to the path "C:\Temp" is denied". However when i use the "XML file location" with the same path. it works fine.

    Please let me know if anyone have an idea about this error.



  • Never Mind, I found the problem.

    Variable has not taken the full file name.

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

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