Pass filename with records while reading multiple files

Kumar1234 · Post by **Kumar1234** » Mon Nov 26, 2012 6:41 pm

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

BrunoD · Post by **BrunoD** » Mon Dec 10, 2012 12:51 pm

Hi,
Did you get any solution? I have a similar scenario.
Thanks.

chulett · Post by **chulett** » Mon Dec 10, 2012 11:21 pm

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.

Kumar1234 · Post by **Kumar1234** » Mon Apr 01, 2013 11:03 am

sorry I forget to reply to this post. When you read the XML in XML-Input stage you can add FileName column with VARCHAR 255 in output along with other attributes and it will automatically populate the filename to your output.