Moving RDF feeds to sql2000

I am trying to grab feeds from craigslist and insert them into a
sql2000 table. I figured bulkload in sqlxml would work. But craislist
uses rss v.1 (aka RDF) instead of rss v2(which I have no problem
inserting). But it looks like RDF is too complex a structure to create
a schema. I scoured the net for most the day trying to figure out how
to import RDF into SQL without any luck. I would like a solution that
can run in a DTS perhaps with ActiveX. Really all I'm looking for is
examples of parsing RSS v.1 (RDF). I've found dozens for RSS v.2. Many
thanks in advance.
You could write your custom shredder using OpenXML in a stored proc.
Best regards
Michael
"MrKnital" <knital@.geocities.com> wrote in message
news:1119137306.602662.108860@.g44g2000cwa.googlegr oups.com...
>I am trying to grab feeds from craigslist and insert them into a
> sql2000 table. I figured bulkload in sqlxml would work. But craislist
> uses rss v.1 (aka RDF) instead of rss v2(which I have no problem
> inserting). But it looks like RDF is too complex a structure to create
> a schema. I scoured the net for most the day trying to figure out how
> to import RDF into SQL without any luck. I would like a solution that
> can run in a DTS perhaps with ActiveX. Really all I'm looking for is
> examples of parsing RSS v.1 (RDF). I've found dozens for RSS v.2. Many
> thanks in advance.
>