Best way to load XML files to SQL Server using C#


  • I'd like to use SQLXMLBulkLoad, but I do not know nothing about XML files which have to be imported to temporary DB on SQL Server (without constraints, references, etc.). As far as I know SQLXMLBulkLoad requires schema for each XML document. Is there any way to create schema dynamically? Or, probably, there is better way to do what I need?

    I'm not able to use SSIS.


    Tuesday, December 06, 2011 8:39 AM


All replies