[
Lists Home |
Date Index |
Thread Index
]
Note that the SQLXML XML Bulkload object is based on a SAX parser. So
you should not have a problem with a file that size.
Best regards
Michael
> -----Original Message-----
> From: Michael Champion [mailto:michaelc.champion@gmail.com]
> Sent: Friday, January 07, 2005 12:37 PM
> To: william.j.boxall@accenture.com
> Cc: XML Developers List
> Subject: Re: [xml-dev] Large xml processing into SQL Server
>
> On Fri, 7 Jan 2005 14:14:18 -0600, william.j.boxall@accenture.com
> <william.j.boxall@accenture.com> wrote:
>
> > Thank you all who have offered to help!
>
> Have you looked at
> http://www.awprofessional.com/articles/article.asp?p=102307 ? It's a
> sample chapter" Using SQL Server's XML Support" By Ken Henderson.
> from The Guru's Guide to SQL Server Architecture and Internals.
> (Addison Wesley Professional.) It discusses bulk loading.
>
> Since your file seems to be structured into relatively simple records,
> can you just break up the file into smaller chunks?
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://www.oasis-open.org/mlmanage/index.php>
|
