On running SQLBULKLOAD I get a couple of errors.
If I point directly to the path of the schema like :
objbl.Execute("C:\Users\Sim\Documents\Visual Studio 2008\WebSites\acVita\Data\Schema\PoRSchema.xsd", "C:\Users\Sim\Documents\Visual Studio 2008\WebSites\acVita\Data\PORM.xml")
I get "The statement has been terminated" message
However if I change this to point to the relative location if I point to a relative directory as :
objbl.Execute("~/Data/Schema/PoRSchema.xsd", "~/Data/PORM.xml") I get the message : "Schema: unable to load schema 'PoRSchema.xsd'. An error occurred (Unknown Error). "
I would have though that the two should produce the same message. But the issue is getting the BULKLOAD to accept the schema. I have checked the schema as valid using Liquid XML Studio. Any suggestions on routes I should atke to resolve this.
which I beleive are related to the schema files. the messages are