parse text files using field data defined in xml
tried to google this but no idea how to define the search.
Looking to do a POC for parsing various file formats (mostly delimited and fixed length) where the variable names, data types etc are all defined in an xml file.
The idea is to re-use this code in various programs rather than a proprietary ETL tool or SSIS. 1 is limited in it's ability, 1 is limited in its ability to be maintainable with lengthy programs that contain many conditional calculations.
Any ideas on information or thoughts on how to word what I'm looking for in a search engine?
Thanks in advance.