Hi We are trying to consume an application generated SOAP WSDL from SSIS. We are able to connect and retrieve the WSDL and generate the XML file using the webservice connector sucessfully. The XML file is as shown below. But it is missing the column names and datatypes are being represented as column names. Also it appears all columns are in one row when I try to use XML source (generate XSD file) in Data flow to consume this file and load it into a DB. 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. Any guidance is much appreciated.
Edited by moderator
2017-05-12T11:54:00Z
|
Reason: Not specified