+ Reply to Thread
Results 1 to 4 of 4

XML Source multiple namespaces problem

  1. XML Source multiple namespaces problem

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

    This is the error message I got when I try to generate de XSD from my
    XML file. This step is at the level of specifications of the "XML
    Source" in the "Data Flow", why is there a restriction on multiple
    namespaces, is there any work around of this? Strange, my XML is a
    valid XML file so why SSIS does not handle a more complicated things?

    I'm doing a POC so I hope I'll find a solution for this, otherwise
    we'll chose other products

    Regards,
    Stefan
    http://www.itsconsulting.fr

  2. RE: XML Source multiple namespaces problem

    "Stefan" wrote:

    > Unable to infer the XSD from the XML file. The XML contains multiple
    > namespaces
    >
    > This is the error message I got when I try to generate de XSD from my
    > XML file. This step is at the level of specifications of the "XML
    > Source" in the "Data Flow", why is there a restriction on multiple
    > namespaces, is there any work around of this? Strange, my XML is a
    > valid XML file so why SSIS does not handle a more complicated things?
    >
    > I'm doing a POC so I hope I'll find a solution for this, otherwise
    > we'll chose other products
    >
    > Regards,
    > Stefan
    > http://www.itsconsulting.fr
    >


    Hi Stefan,

    I recently had the same problem. In order to get around this I created an
    XML Task within the Control Flow and applied an XSLT which removes the
    namespaces. The following article is very useful for this part of the task:

    http://sqljunkies.com/WebLog/ashvini...e/2005/05.aspx

    After the XSLT has been applied then you can use the XML Source in the Data
    Flow without an issue.

    Hope that helps!

  3. Re: XML Source multiple namespaces problem

    "I recently had the same problem. In order to get around this I created an
    XML Task within the Control Flow and applied an XSLT which removes the
    namespaces. The following article is very useful for this part of the task:

    This article is no longer available, is there anyway you could send or post the script that is identified here?

    Thanks In Advance!

  4. Re: XML Source multiple namespaces problem

    The article mentioned with the following script is no longer available. Would you possibly send me or post this script for me.
    Thanks!

+ Reply to Thread