SQLXMLBulkLoad with a remote XML file

• michel-991552

  SSC Rookie

  Points: 44

  More actions

  January 18, 2009 at 2:13 pm

  #71227

  Hi,

  I need to insert to SQL 2000 some data from an XML file. Using the code bellow is working fine but trying to replace "c:\data.xml" with "http://www.domain.com/data.xml" is not working.

  I have been told to change the schema and I've been trying to understant it but I can't figure it out.

  set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")

  objBL.ConnectionString = "provider=SQLOLEDB;data source=localhost;database=tempdb;integrated security=SSPI"

  objBL.KeepIdentity = false

  objBL.ErrorLogFile = "error.xml"

  objBL.Execute "c:\schema.xml","c:\data.xml"

  This is my schema:

  <Schema xmlns="urn:schemas-microsoft-com:xml-data"

  xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"

  xmlns:sql="urn:schemas-microsoft-com:xml-sql">

  Any help would be apreciated.

• michel-991552

  SSC Rookie

  Points: 44

  More actions

  January 18, 2009 at 4:03 pm

  #928980

  I found a solution to my problem.

  I found WGET.EXE and I use thie goody to download the xml file to my local disk.

  This works for me.