Post reply

XML to SQL table

  • July 15, 2009 at 10:11 am

    #133960

    I am trying to load the xml file to sql table and this xml file is out of web service.

    When i try to click on generate scheme in xml source i get the below error.

    Unable to infer the XSD from the XML file. The XML contains multiple namespaces. (Microsoft Visual Studio)

    Is there a way to generate the XSD?

  • July 15, 2009 at 2:51 pm

    #1025367

    I think you have to generate the XML file first and then use an XML source adapter to connect the XML file. In the XML Source Adapter there is an option to generate the XSD file automatically. Store it on the disk and use it within your package

  • July 15, 2009 at 2:53 pm

    #1025369

    That's what I've done to generate the file as well.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 16, 2009 at 9:49 pm

    #1025987

    i tried thru generate xsd and got this error

    Unable to infer the XSD from the XML file. The XML contains multiple namespaces. (Microsoft Visual Studio)

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

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