Outside of loading those packages into an XML column and then parsing the XML using T-SQL, I'm figuring you would need to use VBScript or VBA to parse each file.

You've placed the SumInsured query inside of a LEFT JOIN, but not done any JOINs within that SumInsured query to ensure it's the Client class 1 type.   You can add...