Creating RSS XML feed from SQL Server Table data

• bkirk

  SSCrazy

  Points: 2824

  More actions

  April 27, 2009 at 4:13 pm

  #95192

  Can anyone recommend a 'best practice' for producing an RSS feed using XML output files on my server that people can subscribe to?

  I have 3 SQL Tables containing the following data:

  1) HTML News Articles - stored as nvarchar(max)

  2) Podcast Audio data - actual MP3 files are located on the server and the SQL data simply points to the URL location to play them.

  3) Videocasts - Simply points to youtube URL's.

  I want to be able to create 3 individual RSS feeds using each of these tables and my understanding is that i need to product a properly formatted XML file on my server using the SQL row data.

  The main target for these RSS feeds is Apple iTunes so i realise already that there are specific tags i can use for them.

  What is the best way to product these XML files?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 28, 2009 at 6:09 am

  #985000

  Jacob Sebastian wrote an excellent series on XML for SSC and later articles discuss generating an RSS Feed. I would start with his XML Workshop

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question