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.