I'm trying to use Doug Hennig's BulkXMLLoad code to fill SQL Server tables from VFP tables. I was successful with smaller sizes, but when I try to send in bigger tables, I'm getting error 43, 'there is not enough memory to complete this operation.'
http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html Does anyone have experience with this process? Can that be worked around, or do I need to partition the tables to get them loaded? I'm happy with what I've seen so far. In terms of performance, this seems much faster than other methods I've tried when just doing mass inserts.
Jim Newsom
IT Director, ICG Inc.