Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 xmlbulkload identity column propagation

Author  Topic 

guest_05022009
Starting Member

1 Post

Posted - 2009-05-02 : 07:06:42
Hi all,

I have a parent table and 30 child tables in my database. the parent table has an identity column as primary key. my question is, is there a limit to the number of child tables this identity key can be cascaded thru xmlbulkload? coz if i limit child tables to 28 it works just fine, but when i correlate the 29th one, it starts inserting 0 in all the child tables. Appreciate your help.

Regards.
   

- Advertisement -