• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 574
  • Last Modified:

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\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.
I get

 which I beleive are related to the schema files. the messages are
Simon Cripps
Simon Cripps
1 Solution
Simon CrippsAuthor Commented:
On making a couple of changes i have worked partly through this. I am ignoring the issue with reagrds to an Unknown error as this seams to be to do with how I point to a fille and this can be resolved at a later date.
With regards to the "Statement has been terminated" this was resolved by a couple of changes.
in <@Page I inserted AspCompat="true" and in the XSD I removed sql:is-constant="1" from the first element. this appears to do the trick for now.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now