Post reply

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

  • April 23, 2009 at 2:15 pm

    #131511

    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 12:06 pm

    #983749

    Hi Karen,

    I just tested both of your attached files and both show up using the code you provided.

    There seems nothing to be wrong.


    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]

  • April 24, 2009 at 12:20 pm

    #983764

    I must be looking at something incorrectly then - I'm attaching a screenshot of the results when I run the two different files. The first shows content in the results, and the second appears empty. Can you explain the difference in what you're seeing, and what might possibly explain the different results that we're getting? I'm truly stumped!

  • April 24, 2009 at 12:44 pm

    #983784

    Hi Karen,

    I can't really see any difference.

    Attached please find a screen shot of the code I used and the results I got.

    Looks like the code is identical to yours.

    Are you sure that the file you're trying to open isn't empty?

    Did you try open it with another XML reader?


    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]

  • April 24, 2009 at 12:52 pm

    #983789

    If you look at my jpg, the bottom image shows emtpy results - nothing shows up under "No column name / row 1" while yours shows what it is supposed to. I'm using the files attached earlier, and they are both the same ones you're using, and they're both giving you results. I can't figure it out! Any files that I call the function on other than that first one that gives me results returns that emtpy result. And it isn't doing it for you. I can't seem to get it to work, and you can't seem to get it to fail, same files. ARGGGHH!! I swear, the file isn't empty. It opens in any XML viewer. It cecks out for form, etc. ????

    Has anyone else encountered a similar problem?

Viewing 5 posts - 1 through 4 (of 4 total)

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