Hi,
I have some xml file like
<xml>
<file-location directory="c:\temp" foldername="core.txt"></file-location>
<file-location directory="c:\temp" foldername="menu.csv"></file-location>
<database username="xxx" password="ccccc"></database>
</xml>
I have xml file in this format like it contains file names and database login details also.My question is am extracting xml file using ssis to sql operation in the middle i am reading the text or csv files in that required location and read the data and stored into database. How can i read these text files and stored into database. this total was done in the middle of xml to sql operation in ssis. Can any one help me please,its very urgent for me