0 Replies Latest reply: Oct 21, 2011 10:32 AM by juerg maier RSS

    from_field for extracting xml-values

      Hi

       

      I access a ssrs reporting server to retrieve information on published reports.

       

      The query returns an XML with the embedded report information.

       

      I can capture the report definition with

       

      Reports:
      SELECT Name, CAST(CAST(Content AS VARBINARY(MAX)) AS XML) AS ReportXML
      from <my_SQL_table>;
      
      

      I currently use a macro to dump the XML-Data back into report files and used the Table Files Wizard to get the XML values.

       

       

      LOAD xmlns:rd,
          xmlns,
          Width
      FROM <my_dump_file> (XmlSimple, Table is [Report]);
      
      

       

      I then read about the "from_field" command and thought I could circumvent the macro step and simply read from the above "ReportXML" field.

       

       

      LOAD xmlns:rd,
          xmlns,
          Width
      FROM_FIELD (Reports, ReportXML) (XmlSimple, Table is [Report]);
      
      

       

      This however gives me an "Unknown Error in MSXML".

       

      An example I found used @1 to refer to the FROM_FIELD content but I can't figure out how to script that.

       

      Thanks