0 Replies Latest reply on Feb 19, 2007 11:27 AM by Don_Myers

    SQLXMLBulkLoad How to call it

    Don_Myers
      Hi there,

      I am having a tough time trying to get the SQLXMLBulkLoad to work using Coldfusion. It is easy in .vbs I have tried it as an object but I am not sure if I am going about it correctly. My knowledge of the "cfobject" use is limited. I do not want to polute my Coldfusion code with a .vbs page if I don't have to.

      Here is how it's done in .vbs

      Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
      objBL.ConnectionString = "provider=SQLOLEDB.1;data source=TSB;database=MyDatabase;uid=sa;pwd=sa"
      objBL.ErrorLogFile = "C:\Inetpub\wwwroot\xmltransform\error.log"
      objBL.Execute "C:\Inetpub\wwwroot\xmltransform\customermapping.xml", "C:\Inetpub\wwwroot\xmltransform\customers.xml"
      Set objBL = Nothing

      Any help at this point will be helpful.

      Don Myers