Insert XML Blob into a SQL Database?

[Kyle.Allbright]

Can anyone point in the a good direction of how to insert an XMLDocument into a SQL Server: The column on the "Xml_File" is of datatype: XML

Thank you, and yes, I have googled it lol........Can't seem to find a good resource of uploading it as a blob instead of a string

 

[svetlanija]

Dim objBL As Object
objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

objBL.ConnectionString = " Provider=sqloledb;Data Source=.\sqlexpress;Initial Catalog=dbname;Integrated Security=SSPI;"

objBL.ErrorLogFile = "c:\error.log"

objBL.KeepIdentity = False

objBL.Execute("c:\schema.xml", "c:\xmlfile.xml")

objBL = Nothing

 

[JohnH]

Working with SqlXml