Home Forums SQL Server 2012 SQL 2012 - General Fastest Way to consume large XML files RE: Fastest Way to consume large XML files
HowardW
One Orange Chip
Points: 29109
More actions
July 28, 2014 at 5:13 am
#1732759
There's a basic tutorial here:
http://sql31.blogspot.co.uk/2013/03/how-to-use-script-component-as-data.html
Basically, most of your code goes into CreateNewOutputRows() and you just call Output0Buffer.AddRow() as you iterate through the XMLReader...