Hi,   I am reading huge xml files using xmlv2 libname and xmlmapper file. After reading the each file, I need to add a source filename to the output dataset. I can not use INDSNAME option because I must use PROC APPEND.   Because my source file has missing columns or additional new columns every time. This can be done only using PROC APPEND with FORCE option. Hence kindly guide me how can I add a new column in PROC APPEND?   Thanks Arun     ... View more

I didn't write any code at all. XML Mapper auto generates the XML Map file for your XML file, as along structure is same there is no need to touch the XML map.   DI Studio represents that XML file as table in metadata and use Table loader to load into SQL Server directly. No code.    I do not have experience in Talend but I believe it is similar except Map file is generated inside the Talend tool. when XML file structure changes then you still need readjust the XML Map transformation according to new structure in Talend . ... View more