Post reply

XML file conversion to load TABLE

  • May 15, 2017 at 6:44 pm

    #321412

    Hi I am new to SSIS and we have a in house application that generates a WSDL. I am using the webservice task to read the wsdl and I am able to download the XML successfully. But numerous attempts to convert this using XML source to an XSD file to load the Data into the table have been useless. This is how the xml is 

    <?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">1999</anyType>
      <anyType xsi:type="xsd:string">check</anyType>
      <anyType xsi:type="xsd:double">3</anyType>
    </ArrayOfAnyType>
    <ArrayOfAnyType>
      <anyType xsi:type="xsd:double">2000</anyType>
      <anyType xsi:type="xsd:string">check1</anyType>
      <anyType xsi:type="xsd:double">3</anyType>
    </ArrayOfAnyType>
    <ArrayOfAnyType>
      <anyType xsi:type="xsd:double">2001</anyType>
      <anyType xsi:type="xsd:string">check2</anyType>
      <anyType xsi:type="xsd:double">3</anyType>
    </ArrayOfAnyType>
    <ArrayOfAnyType>
      <anyType xsi:type="xsd:double">2002</anyType>
      <anyType xsi:type="xsd:string">check4</anyType>
      <anyType xsi:type="xsd:double">3</anyType>
    </ArrayOfAnyType>
    </ArrayOfArrayOfAnyType>

    These are the columns in the table 

    ID, Check_source, value
    Can i use PIVOT,ROWSAMPLING, UNPIVOT Transformations to covert this the desired format.
    Or is there any way i can convert this xml to load data into the destination OLEDB table.

    Any help is appreciated

  • May 16, 2017 at 12:07 pm

    #1942757

    Can anyone help here please. Can I use a script component in data flow and achieve this? Please i need some guidance and help.

Viewing 2 posts - 1 through 2 (of 2 total)

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