I am reading multiple xml files using file pattern (*.xml) and loading into a teradata table. I have a requirement to pass the filename along with the records. I need to do this on server job as the current design already exist and this is an addition.
I searched the forum, but did not find any favorable solution.
Kindly Help....
Pass filename with records while reading multiple files
Moderators: chulett, rschirm, roy
Pass filename with records while reading multiple files
Thanks...Kumar
How similar? For anything other than exactly the same you should start your own post.
If you are processing XML files in a Server job you should be using a Folder stage and that can automatically pass in the name of the file along with the file contents.
If you are processing XML files in a Server job you should be using a Folder stage and that can automatically pass in the name of the file along with the file contents.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers