Link to home
Start Free TrialLog in
Avatar of Simon Cripps
Simon CrippsFlag for United Kingdom of Great Britain and Northern Ireland

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\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
ASKER CERTIFIED SOLUTION
Avatar of Simon Cripps
Simon Cripps
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial