Post reply

XML Source : Access to the path is denied error

  • January 12, 2012 at 2:40 am

    #391293

    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.

    Thanks,

    Karthik

  • January 12, 2012 at 3:43 am

    #1432324

    Never Mind, I found the problem.

    Variable has not taken the full file name.

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

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