DSXchange

Hi All,

I have one server job which is reading multiple XML files.The job design is like this

Folder --> XML I/P --> Trans`r --> Seq file

In folder stage i am using *.XML wildcard for file name. I want to get the filename against each record processed in the seq file for tracking purpose.

Pls give your inputs on the above requirement.

You've already got it in the folder stage, yes? Just pass it through all the way to the Sequential stage. Anything in an XML stage without an XPath expression in the Description column is such a 'pass through' value and will be propogated out the other side.

The only other issue might be if the Folder stage is set to 'Fully qualified' and all you want is the filename. In that case strip out just the portion after the last delimiter in the transformer.

Thank you Mr. Craig Hulett

with your suggestion i am able to do it