April 19, 2011 at 2:56 pm
Hi,
I have to process a huge xml file and I wanted to split the file into multiple xml files. Can someone help me in splitting a file back on the containers.
I am able to get the count of the notes using xquery but unable to get the xml doc from that node point to the next one.
Thanks
April 27, 2011 at 10:38 pm
Can you provide more information? Just curious why you not using stagging table and use T-SQL to perform ETL.
---------------------
Free tool to document sql server database | Free SSIS Tasks and Components
April 28, 2011 at 7:47 am
I am storing the data in the tables however, the XML which comes in has 1000s of nodes/containers and multiple subroot elements. Therefore I decided to take 1 subroot at a time process the schema, validate the data and then store it on the table. I used xquery to perform these actions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply