Read XML Feed

• Marcus Farrugia

  SSCarpal Tunnel

  Points: 4718

  More actions

  August 26, 2015 at 2:41 pm

  #320132

  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.

• pietlinden

  SSC Guru

  Points: 63591

  More actions

  August 26, 2015 at 3:46 pm

  #1822631

  Maybe start here:

  https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/