SQLXMLBULKLOAD statement has been terminated

Posted on 2009-12-30
Last Modified: 2012-05-08
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
Question by:Simon Cripps
    1 Comment

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now