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
 General SQL Server Forums
 New to SQL Server Programming
 Alternative to SQLXMLBULKLOAD ?

Author  Topic 

JeffT
Posting Yak Master

111 Posts

Posted - 2008-05-02 : 09:10:25
Hi,

Just curious, is there any alternative to SQLXMLBULKLOAD for shredding and loading very large (800 megs) XML files ? Due to the nature of the XML data sent to me (which I have no control over)I am having great difficulty loading data into tables. More specifically, I can load parent data but not the child data beneath it despite using sql:relationships.

Thanks,
Jeff

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-02 : 13:17:40
Not sure its what you're after, but this link discusses some of methods for loading xml to table.

http://msdn.microsoft.com/en-us/library/ms191184.aspx
Go to Top of Page

JeffT
Posting Yak Master

111 Posts

Posted - 2008-05-02 : 13:51:34
Thank you !
Go to Top of Page
   

- Advertisement -