The data is inserted via SSIS, we receive around 10 files which are loaded into holding tables and a vary large set of manipulation is run on the data to create the correct data what we need for our apps.

The process is run so infrequently that we have made a decision to download the files before hand, and open / save this file in notepad etc as Unicode then upload it to the servers.

Going to investigate a C# or VB script which will do the conversion for us before it is passed to the data flow task.