Simon Cripps
asked on
SQLXMLBULKLOAD statement has been terminated
On running SQLBULKLOAD I get a couple of errors.
If I point directly to the path of the schema like :
objbl.Execute("C:\Users\Si m\Document s\Visual Studio 2008\WebSites\acVita\Data\ Schema\PoR Schema.xsd ", "C:\Users\Sim\Documents\Vi sual 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/Sche ma/PoRSche ma.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.
I get
which I beleive are related to the schema files. the messages are
If I point directly to the path of the schema like :
objbl.Execute("C:\Users\Si
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/Sche
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.
I get
which I beleive are related to the schema files. the messages are
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.