SQLXMLBulkLoad Error

  • sariel.wong

    SSC Rookie

    Points: 27

    Dear All,

    I am new on using SQLXML Bulk Load object to import XML to SQL server for further checking, for the test i would like to current several tables from XML

    • ListRecords - The list of people
    • ListRecordsDate - Date information for people in listRecords, which i would like to store both DateType and Date Information into this table

    Currently I have XSD definition and XML attached. However the following error when i execute the VBS

    As the XML file is provided by another party and we cannot modify anything from it. Appreciated if anyone can advise

    In addition, there is a new requirement to include Information to SQL tables, e.g.

    <Information>
        <Name>XXX</Name>
        <Address>1 ABC Building</Address>
        <Address>DEF Street</Address>
        <Phone>2345679</Phone>
        <Phone>4455113</Phone>
    </Information>

    It would be appreciated if anyone can guide me to achieve the goal

  • Eirikur Eiriksson

    SSC Guru

    Points: 182343

    Have you validated the XML against the XSD?
    😎

  • sariel.wong

    SSC Rookie

    Points: 27

    of course, no error.

    Appreciated if you can advise how i can modify the XSD for SQLXMLBULK LOAD

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

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