|
Home > Archive > MS SQL XML > January 2006 > break up list during bulk load?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
break up list during bulk load?
|
|
| SeanGerman@gmail.com 2006-01-10, 1:23 pm |
| 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 Rys [MSFT] 2006-01-12, 8:24 pm |
| 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.googlegroups.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.
>
| |
| SeanGerman@gmail.com 2006-01-13, 9:23 am |
| Michael,
Yeah, that's what I suspected. Thanks for the reply.
Sean G.
|
|
|
|
|