Does anyone have any experience, tips, etc., about importing XML files containing data from different but related record structures?
IOW, each XML data file contains various levels of One-To-Many (Parent-To-Child, if you will) related records. This is part of an ETL (Extraction, Translation, Load) process, wherein RBase will be the intermediate tool, i.e. XML => RBase => SQL Server/web-based vertical app'. I have found various free/free-to-try tools, but nothing that suits my needs to a 'T'. I can get the XML data into a big flat file/spreadsheet and one tool even splits the different (Parent, Child) record structures into CSV files, but doesn't preserve a common linking, PK/FK value. If I can't find a free, easy-to-use tool, that does everything I want - don't suppose I'm asking for too much, there! - I'm thinking about importing the denormalized flat file with all its nulls and doing something with GROUP BY's and/or DELETE DUPLICATES. I'd appreciate any information anyone might have.I find Thanks, Steve in Memphis
