XML import from URL -- how to do it?

• Wedge78

  Ten Centuries

  Points: 1102

  More actions

  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

   

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  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!

• Wedge78

  Ten Centuries

  Points: 1102

  More actions

  July 3, 2007 at 8:57 am

  #716909

  Thanks I figured that out eventually.

  Lots to learn....Lots to learn

  cheers