Splitting XML document into multiple batches

  • 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

  • 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

  • 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