What about just consuming http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml ?

Converting that into a table is also very simple.

Thanks for the improvement. I have been testing on a server, and in both cases I see no significant difference. Good hardware has made me lazy.

Most of this discussion has...

I have tackled this problem before. I retrieve the XML data directly from the ECB site, within a web application written in C#. The XML data is given as a...

I have used XML to insert multiple rows using a SP for years now. I certainly see the benefits. There is a huge performance boost when inserting data aggregations that...