Post reply

OPENROWSET load of XML file showing empty result for *most* files

  • April 24, 2009 at 10:36 am

    #100617

    I'm running the following:

    DECLARE @xml XML;

    SELECT @xml = BulkColumn

    FROM OPENROWSET (BULK 'C:\WMG\DeltaFiles\delta_metadatacatalog.xml', SINGLE_BLOB) TempXML

    SELECT @xml;

    If the contents of the referenced file are really simple and I keep the file size super-small, I see the XML in the final select statement. As soon as I change the contents to something larger, all bets are off - the result is empty. In every case the XML is well-formed - I've checked it every time. I'm attaching two files to use as an example (the names indicate what results are returned from each) - Are there some limitations to this command that I'm not aware of? Alternatives I can try? Any help on this would be GREATLY appreciated!! - Thanks in advance!

    -Karen

  • April 24, 2009 at 11:57 am

    #983741

    Please don't cross post.

    For replies please refer to post http://www.sqlservercentral.com/Forums/FindPost703604.aspx


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply