BusinessObjects Board

Web Intelligence SOAP WSDL

dataservices realtime
#1

Hi We are trying to consume WEBI generated SOAP WSDL from SSIS. We are able to connect and retrieve the WSDL and generate the XML file. The XML file is as shown below. But it is missing the column names and datatypes are being represented as column names. How can I overcome this.

<?xml version="1.0" encoding="utf-16"?>
<ArrayOfArrayOfAnyType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ArrayOfAnyType>
    <anyType xsi:type="xsd:double">2150291</anyType>
    <anyType xsi:type="xsd:string">SPED</anyType>
    <anyType xsi:type="xsd:double">3</anyType>
  </ArrayOfAnyType>
  <ArrayOfAnyType>
    <anyType xsi:type="xsd:double">2508589</anyType>
    <anyType xsi:type="xsd:string">MSGENERALIST</anyType>
    <anyType xsi:type="xsd:double">3</anyType>
  </ArrayOfAnyType>
  <ArrayOfAnyType>
    <anyType xsi:type="xsd:double">2520912</anyType>
    <anyType xsi:type="xsd:string">ELEMENTARY</anyType>
    <anyType xsi:type="xsd:double">3</anyType>
  </ArrayOfAnyType>
  <ArrayOfAnyType>
    <anyType xsi:type="xsd:double">2554521</anyType>
    <anyType xsi:type="xsd:string">HSMATH</anyType>
    <anyType xsi:type="xsd:double">3</anyType>
  </ArrayOfAnyType>
</ArrayOfArrayOfAnyType>

I am new to the SSIS, ETL world been more on the Univ and report development side. Any guidance is much appreciated.

[Moderator Edit: Added code formatting - Andreas]

monty4u :us: (BOB member since 2006-12-12)

#2

I think you are probably posting in the wrong place. You would either post over on the Webi side (for how to fix the output of their WSDL) or in an SSIS forum about how to overcome your issue with SSIS. This is an SAP Data Services forum.

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)