Hi , Sorry might be my post is little late, so what we did for the RSS data load is :-
1) Load or create the field structure in Adobe OOTB xls format.
2) ftp download the xml file (the content file).
3) Using OOTB function applyXslFromFile to validate the RSS data feed.
4) Later assign the data to the array fields.
5) Insert or update array data to the table.
Thanks,
Adithya