I have a huge xml file which I need to parse and load into a database. The file is about 1.7 Gig! Fun!
I initially tried to use an XML source but I get an OutOfMemoryException error. Is it possible to use an XML source and optimize the memory use so that it can run?
If not, is there a good place to go to for learning how this could be done in a script task? I have many nodes that need to be joined together in order to flatten the data, but I have no experience with scripting xml.
Thanks for any advice on this,
View Complete Post