| Bertan ARI [MSFT] 2005-07-11, 8:24 pm |
| Bulkload uses the relationship information given in Annotated XSD to
determine the insertion order of the rows.
Is it possible for me to take a look at your Annoated XSD and more
clarification on which tables are inserted in wrong order?
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Doug Kent" <dkent@_n_o_s_p_a_m.austin.rr.com> wrote in message
news:vPXye.98023$j51.30598@tornado.texas.rr.com...
> Hello,
>
> I'm using XML Bulk Load to insert rows into multiple tables having
> primary/foreign key relationships.
>
> XML Bulk Load is inserting into one of the child tables before it has
> created the parent table row. This is causing a foreign key constraint
> violation.
>
> All the other tables are working fine. Just the one isn't.
>
> The order in which things appear in the annotated schema seems to make no
> difference.
>
> Does anyone know what factors affect the order of tables in which XML Bulk
> Load chooses to insert rows?
>
> Thanks for any suggestions.
>
> Doug Kent
>
>
|