I used to do this kind of thing all the time in a company I worked at a few years ago.

I would query a list of all the companies in the UK (we had lots of company data - but you can easily obtain it), that were listed as a bank.

Then simply match on name - we didn't have SSIS back then and had to use third-party applications but Fuzzy Lookup would do the job I'm sure.