XML Source : Access to the path is denied error

• Krtyknm

  SSC Eights!

  Points: 884

  More actions

  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

• Krtyknm

  SSC Eights!

  Points: 884

  More actions

  January 12, 2012 at 3:43 am

  #1432324

  Never Mind, I found the problem.

  Variable has not taken the full file name.