insert data into sql server

[hiba1]

Hello , 

i try to insert data (cities) into sql server .

this is my job :

I extract "countryCode" from sql server table to get the xml cities of evry country from tsoap response .then i load this xml (evrey xml has the countryCode in his name) into my desk.

soap message

load xml with their countryCode(dynamic)

whene i execute the job i get this files in my desk:

then i produce this :

pase xml files and insert data into sql table 

what i want now is to insert the "codeCountry" of all the cities, 

PS:  a country can has many cities .

Any help please !! 

[Anonymous]

Hello,

A Job links the tFileList and tFileInputXML components.

The file name parameter in the tFileInputXML component is set to:

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

And you should use tMap component in your workflow.

 tfilelist (import all xml files )------>tfileinputxml--->tmap---->DBoutput (table).

Let us know if it works.

Best regards

Sabrina