Hi Sabrina,
Thank you for using Microsoft MSDN Managed Newsgroup.

From your description, I understand that you used SQLXMLBULKLOADLib in a third party software to import data from an XML source into
your database. However you do not want to first delete the data from the table and then bulk insert the data into to the table. You would
like to have it update existing records and only insert new records which do not exist in the table. Also you would like to modify your
schemas to include the relationships and keys in an easy way but not manually.
If I have misunderstood, please let me know.

Unfortunately what you were asking for are product limitations in SQLXMLBULKLOADLib. SQLXMLBULKLOADLib does not provide update
data function. If you want this function, you need to code to implement it by yourself. If there are large of data, checking for update may
also lead to performance issue. Generally the existing known methods or tools like bcp, XML Source (in SSIS), Data Import/Export etc,
they all do not provide such function. If you need to check each row for update, there might be not any performance advantage for BULK
operation. In my opinion, dumping the contents first is a reasonable design, especially from performance perspective. I recommend that
you review your requirements to see if you really want update in a bulk load operation. If this is required, you may consider rewriting your
application to implement this function.

SSIS XML Source can automatically generate a matched XSD schema for an XML source, however currently it is simple and will not include
the relationships and keys. You need to manually include the relationships and keys in your schema file. I am not sure if there are third-
party tools supporting this feature. You may contact your application vendor or some third party Dev forums for consulting this.

Appreciate your understanding on this. Please feel free to let me know if you have any other questions or concerns.


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial
response from the community or a Microsoft Support Engineer within 2 business day is
acceptable. Please note that each follow up response may take approximately 2 business days as
the support professional working with you may need further investigation to reach the most
efficient resolution. The offering is not appropriate for situations that require urgent, real
-time or phone-based interactions. Issues of this nature are best handled working with a
dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======