x

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 '10 at 09:08 AM in Default

Stevo72 gravatar image

Stevo72
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 '10 at 12:58 PM

user-1023 gravatar image

user-1023
11

does this apply for SQL2005 or just SQL2008?
Jan 26 '10 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x136

asked: Jan 26 '10 at 09:08 AM

Seen: 850 times

Last Updated: Jan 26 '10 at 09:08 AM