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.

How is this related to VisualCron? I mean, what do you want to do with the content in VisualCron?

---

Sorry thought this forum was to help folks with general issues related to SSIS, SQL server. Thanks will pursue this elsewhere.