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.
XML filename for each record processed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
XML filename for each record processed
Thanks,
Sourabh Verma
Sourabh Verma
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am