break up list during bulk load?

Howdy,
I'm doing a bulk load with SQLXML 3.0 and MS SQL 2k. One of the
elements is a (long) comma-space delimited list of quoted URIs. In my
working schema the list is loaded into a child table as a single long
varchar with a key to the parent table.
I'd like to have each URI in its own record in the child table. I've
messed around a bit with xsd:list and simpleType, but BulkLoad is
hearing none of that.
Has anyone any experience manipulating lists with the schema in
BulkLoad? (I can break the list up into individual elements with a
regex on the XML or transform the records with a sproc after loading,
but I'd like to handle this in the bulk load without modifying the xml
data if possible.)
TIA,
Sean G.
Sorry, but that is not possible in the SQLXML Bulkload object...
Best regards
Michael
<SeanGerman@.gmail.com> wrote in message
news:1136915537.981406.87190@.o13g2000cwo.googlegro ups.com...
> Howdy,
> I'm doing a bulk load with SQLXML 3.0 and MS SQL 2k. One of the
> elements is a (long) comma-space delimited list of quoted URIs. In my
> working schema the list is loaded into a child table as a single long
> varchar with a key to the parent table.
> I'd like to have each URI in its own record in the child table. I've
> messed around a bit with xsd:list and simpleType, but BulkLoad is
> hearing none of that.
> Has anyone any experience manipulating lists with the schema in
> BulkLoad? (I can break the list up into individual elements with a
> regex on the XML or transform the records with a sproc after loading,
> but I'd like to handle this in the bulk load without modifying the xml
> data if possible.)
> TIA,
>
> Sean G.
>
|||Michael,
Yeah, that's what I suspected. Thanks for the reply.
Sean G.