Trouble with XML Bulkloading from a stream

Hot Topic

Cannot Install SQL 2005 Failed to compile the Managed Object Format (MOF) file
raw file destination and environment variables
Date Conversion
Cannot delete Sequence Container -- details
Recovering from a lost log file
False hits with Contains query
Error occurring in ExecuteSQL Task in OnPreExecute (and in OnPostExecute) but package not failing
MDX query returns double values
VB.NET 2003 STD WITH SQL SERVER EXPRESS
sql question

SQL Server

SQL Express license hosting for business purpose?
How do I attach query results to send mail
SP1 Question Report Builder Question
How to set an action?
SQL2005 equivalent of the data import task in SQL2000
Thread was being aborted
Executing an external process() in SQLCLR Project
SQL Server 2005 June CTP Install Issue
Replication with filter
Stored procedure issues...

Trouble with XML Bulkloading from a stream

Hi,

I am having trouble bulkloading xml into SQL from a stream.  I am able to bulkload the XML from a file, but I want to load it into an XMLDocument first and then bulkload it.  I understand that the bulkload execute command is overloaded to do this but no matter what I try I get an 'Error opening the data file.' exception. I am using SQLXML 3.0 and C#.  Does anyone have any ideas

Thanks.


Answer this question

Trouble with XML Bulkloading from a stream

  • manix

    Yes, that helped.
    Thanks Bertan.




  • Jerry K

    Hi,

    Unfortunately, you have to pass a stream that implements the native IStream interface which is different than the Stream returned from the XmlDocument.

    There is an article on this issue:

    http://msdn.microsoft.com/xml/default.aspx pull=/library/en-us/dnsql90/html/exchsqlxml.asp

    That should help
    Bertan

  • TerrariumNewbie

    Hi,

    I am using the XMLDocument Save method to save the XMLDocument as a stream then bulk loading the stream.

    Thanks.



  • Chandrak Bhavsar

    I am kind of confused about loading the Xml file into XmlDocument and how you use the Bulkload. Are you passing an XmlDocument to Bulkload If so, this is not possible. You can only pass a file uri or a stream to bulklad as data xml.
  • Trouble with XML Bulkloading from a stream
Answer this question