How do I export data from an XML file to SQL table?
I need to export data from an XML file to update a SQL table. It is only 2 records not the entire table. I'm running this as a vbs. I'm getting a compilation error(Expected statement) This is what I have so far for the mapping: Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "provider=SQLOLEDB.1;data source=MySQLServer;database=MyDatabase;uid=MyAccount;pwd=MyPassword" objBL.ErrorLogFile = "c:\error.log" objBL.Execute "c:\extractor.xml" Set objBL = Nothing