Importing XML Data

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?

Many thanks

more ▼

asked Jan 26, 2010 at 09:08 AM in Default

avatar image

41 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I think you might only be able to do this with a script componet (could be wrong)

This link would be a starting point

more ▼

answered Jan 26, 2010 at 12:58 PM

avatar image


does this apply for SQL2005 or just SQL2008?

Jan 26, 2010 at 02:27 PM Stevo72
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 26, 2010 at 09:08 AM

Seen: 1718 times

Last Updated: Jan 26, 2010 at 09:08 AM

Copyright 2018 Redgate Software. Privacy Policy