Loading all XML files from specified directory

[hiba1]

Hello,

I have a directory containing 38 xml files.What I need to do is to load all of them into one db table (the db is SQL server). 

I try with this job  but i don't know how to configure  the txmlmap to insert all the data into the sql table

 

[Anonymous · Accepted solution]

Hello,

You should use tMap component in your workflow.

The job should be: tfilelist (import all xml files )------>tfileinputxml--->tmap---->DBoutput (table).

Let us know if it works.

Best regards

Sabrina