Ok so with Integration Services (SQL2005) I can import xml files so I'd like to import an rss feed. The XML Source editor requires an xsd file. Does anyone know if there is a standard xsd for rss v2.0 available out there? I've searched and can't find anything other than http://www.codeplex.com/rss2schema which doesnt seem to work, I get an error 'the content of an element can not be declared as anytype'.
Any ideas? I'd have thought publishers of rss feeds should adhere to a specific schema which should be available but maybe I'm barking up the wrong tree?
asked Jan 26, 2010 at 09:08 AM in Default