I am trying to transform a large XML file and load it to SQLServer using bulk load function in MS SQLXML 3.0 with the following VBScript. It works for a file of about 18MB. However, when I try it with a 54MB file, the bulk load function breaks down with "Fatal Error - General Operation Error". Is there any problem with my script? Is there any other better way to do it? I may need to load file of size up to 400-500MB!!

' VBScript
' Flatten nested XML file using XSLT
set xsl = CreateObject("MSXML2.DOMDOCUMENT.4.0")
set xml = CreateObject("MSXML2.DOMDocument.4.0")

xml.validateOnParse = false
xml.async = false
xml.load "c:\temp\sampleXMLData2_b4XSLT.xml"

xsl.async = false
xsl.load "c:\temp\sampleXSLT2.xsl"

set inStm = CreateObject("ADODB.Stream")
inStm.Open
inStm.Charset = "UTF-8"
xml.transformNodeToObject xsl.documentElement, inStm
inStm.Position = 0

' Bulk load flattened XML file
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objBL.ConnectionString = "provider=SQLOLEDB;data source=132.220.138.193;database=LISDB;uid=xxx;pwd=yyy"
objBL.ErrorLogFile = "c:\temp\error.xml"
objBL.Execute "c:\temp\sampleSchema2.xml", inStm
set objBL = Nothing