Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Need help with SQLXMLBulkLoad

Author  Topic  ppuar Starting Member 28 Posts Posted - 2003-01-27 : 19:43:17 I am using the following code in VB: objBulkLoad.ConnectionString = "provider=SQLOLEDB;data source=192.168.90.22;database=test;Integrated Security=SSPI;" objBulkLoad.Execute "c:\test\testSchema.xml", "c:\test\test.xml" This works fine if your data is stored in a file, but my data is stored in a variable. I need to be able to specify a schema and variable: objBulkLoad.Execute "c:\test\testSchema.xml", xmldoc This does not work - Does someone have a work around? Thanks P