August 26, 2015 at 2:41 pm
Hi, I'm trying to find a way to import data from this data xml feed to get daily exchange rates.
I'm a little at a loss at where to begin. I' tried:
select *
from
openrowset(bulk 'http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml',single_blob) as x
which is a feeble attempt at a start; however, am getting this error message:
Cannot bulk load because the file "http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).
Looking for some help or direction on how to parse this file using SQL.
Thank you in advance.
August 26, 2015 at 3:46 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply