Structured .TXT Data To A Proper DBMS
When previously faced with a similar issue I ended up 


writing a pre import parser (c)which ran through the extracted data and created a file of valid entries and a file of malformed entries
Import the valid entries Into
Sql server using the import wizard which was used to create a schedule job for each of the import file types
Once imported there were several jobs that further manipulated the data and copied to the final end user tables. 


The main issue is identifying the malformed data 
And handling it and ensuring that you use the same pattern where possible for all files.