Home Forums Data Warehousing Integration Services Reading Data From XML through Script component RE: Reading Data From XML through Script component

  • February 15, 2013 at 6:09 pm

    #1588566

    opc.three (2/15/2013)

    800MB is an awfully large XML document. Note that when represented in memory as an XMLDocument object it will occupy far more space that just the file on disk. How much RAM is on the machine you are trying this on?

    Try with a smaller version of the file with the same structure and see if you can get a proof-of-concept done.

    I was able to load 200MB of file size through XSLT script in XML task. But Working with 800MB File size is an issue here.

    Is there any better solution you can think of to load 800MB of XML file?