Post reply

XML import from URL -- how to do it?

  • July 2, 2007 at 5:31 am

    #124520

    Hi

    I have been given a url to an xml file on the web. I am tring to use SSIS to import this file into sql server

    I have created a HTTP connection to the URL and the test connection works.

    I then create a web service task to import the data. In the web service task it asks me for a WSDL file. I have no idea what this is talking about. I have read up on wiki and understand its a web services data definition file. Do I create it myself? Do I download it from the site?

    Is this the right way to import this data?

    Any guidance would be appreciated

    thanks

     

  • July 2, 2007 at 9:56 am

    #716573

    Why not just stick the URL into the XML source component?

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • July 3, 2007 at 8:57 am

    #716909

    Thanks I figured that out eventually.

    Lots to learn....Lots to learn

    cheers

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

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