Results 1 to 1 of 1
  1. #1
    Join Date
    May 2003
    Location
    Pinoy in NJ
    Posts
    104

    Unanswered: Importing XML file getting an error [SSIS]

    I'm trying to import an XML file using XML Source but I'm getting an error when I try to generate XSD.

    "Unable to infer the XSD from the XML file. The XML contains multiple namespaces."

    I have been researching on using an XML Task instead but I couldn't figure out how to be able to strip the [xmlns:dt="urn:schemas-microsoft-com:datatypes"] & [dt:dt="xxxxxx"] from the XML source. Without it, I have no issues.

    Any ideas would be appreciated. Thanks!



    <?xml version="1.0" encoding="ISO-8859-1" ?>
    - <POPALL xmlns:dt="urn:schemas-microsoft-com:datatypes">
    - <POP xmlns:dt="urn:schemas-microsoft-com:datatypes">
    <SysDate dt:dt="dateTime">2010-09-24T00:00:00</SysDate>
    <WkStn dt:dt="i4">19</WkStn>
    <Tran dt:dt="i4">106057</Tran>
    <Id dt:dt="string">POP.4001.20100924.19.106057</Id>
    <Store dt:dt="i4">4001</Store>
    <StartTime dt:dt="dateTime">2010-09-25T09:29:33</StartTime>
    <Time dt:dt="dateTime">2010-09-25T09:29:33</Time>
    <ClientId dt:dt="string">WkStn.4001.19</ClientId>
    - <EXTENSIONS>
    <IsExternalEvent dt:dt="ui1">1</IsExternalEvent>
    </EXTENSIONS>
    </POP>
    - <POP xmlns:dt="urn:schemas-microsoft-com:datatypes">
    <SysDate dt:dt="dateTime">2010-09-24T00:00:00</SysDate>
    <WkStn dt:dt="i4">19</WkStn>
    <Tran dt:dt="i4">106058</Tran>
    <Id dt:dt="string">POP.4001.20100924.19.106058</Id>
    <Store dt:dt="i4">4001</Store>
    <StartTime dt:dt="dateTime">2010-09-25T09:32:52</StartTime>
    <Time dt:dt="dateTime">2010-09-25T09:32:52</Time>
    <ClientId dt:dt="string">WkStn.4001.19</ClientId>
    - <EXTENSIONS>
    <IsExternalEvent dt:dt="ui1">1</IsExternalEvent>
    </EXTENSIONS>
    </POP>
    </POPALL>
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •