insert data into sql server

hiba1 — Sat, 16 Nov 2024 05:07:02 GMT

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 !!

Re: insert data into sql server

Anonymous — Wed, 07 Aug 2019 09:24:42 GMT

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

topic Re: insert data into sql server in Talend Studio

insert data into sql server

Re: insert data into sql server