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)
 SQLXMLBulkLoad error trapping

Author  Topic 

Kristen
Test

22859 Posts

Posted - 2006-10-06 : 10:22:45
Is there any way to get errors out of the SQLXMLBulkLoad object?

I've spent two hours tracking down this error - 'coz nothing reported anything amiss, but no data was being imported

<sql:relationship
name="STOCK_DESC"
parent="staging_STOCK_ITEM"
parent-key="DESCRIPTION"
child="staging_WronglySpelledTableName"
child-key="DESC_STOCK_CODE"
/>

The "WronglySpelledTableName" did not exist

Kristen
   

- Advertisement -