Import xml feed directly to table

• Aaron Prohaska

  SSC Eights!

  Points: 982

  More actions

  August 5, 2008 at 11:54 am

  #382156

  We have been given the url of an xml feed and need to import the data into our database table in sql server 2005.

  Can anyone tell me if it's possible to import a xml feed (url) directly? What implications and possible problems is there with importing this way? I imagine that it could be really slow. What other options are there for importing data from a url feed?

  Thanks,

  Aaron

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  August 28, 2008 at 5:31 am

  #864262

  IMHO your best option would be to design a client application for that task.

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com