integrate XML files into SQL database

[ali_hijazi1]

Hello
I'm new to Talend and I downloaded Open Studio for data integration
I have a folder that contains a bunch of XML files (around 120 files)
each file is related to an employee and of course all got the same structure
what i want is to read all of these files and save the data as relational data in MS SQL server

Please advise on how to accomplish this

[Anonymous]

Hi 
Use tFileList to iterate each XML file and parse it with tFileInputXML, merge all the records and load them to MS SQL server. The job looks like:
tFileList--iterate--tFileInputXML--main--tUnite--main--tMSSQLOutput

Please read the component user documentation and learn these components.