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.
| Author |
Topic |
|
__madmax__
Starting Member
31 Posts |
 Posted - 2005-06-01 : 06:19:04
|
Hello all,My challenge is the following. I have a XML file of more or less 30 mb! With this file i need to update my database on a daily basis.So after a little research i think i found the right way to do this; SQLXML Bulkload.On this forum I saw an exmample of how to do this; http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=26828&SearchTerms=SQLXMLBut in this way, i need to loop through al the nodes, and before that is done, i think i am gonna be very old  So i thought i saw a different approach, i think i was something like this;create Object SQLXMLOleDbcreate cn to SQLserverexecute "updategram","xmlfile.xml"Does anyone has any exmaples or pointers for me where to look ?Or do i need to use a total different approach ?(please do not telle me that an update of an xml file of 30mb isn't possible  ) |
|
|
|
|
|
SQMLXML Bulkload