Read of XML File

Hello,
I do have XML file in c:\project.xml, this file is arround 60 MB file.
Now i want to use
EXEC sp_xml_preparedocument @.idoc OUTPUT, @.doc and then OPENXML to load xml
into sql server table, so how can i pass that xml file to
EXEC sp_xml_preparedocument
Pls helpTry this:
http://www.sqlxml.org/faqs.aspx?faq=39
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:B51412BA-DDD2-443C-97B4-4E4E76358A2E@.microsoft.com...
> Hello,
> I do have XML file in c:\project.xml, this file is arround 60 MB file.
> Now i want to use
> EXEC sp_xml_preparedocument @.idoc OUTPUT, @.doc and then OPENXML to load
xml
> into sql server table, so how can i pass that xml file to
> EXEC sp_xml_preparedocument
> Pls help|||Is there anyway so that i c an do bulk load..because my .xml file is very
big, arround 60MB. Pls let me know
"Narayana Vyas Kondreddi" wrote:

> Try this:
> http://www.sqlxml.org/faqs.aspx?faq=39
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:B51412BA-DDD2-443C-97B4-4E4E76358A2E@.microsoft.com...
> xml
>
>