Consuming a WSDL File?

• shjaffer

  SSC Enthusiast

  Points: 127

  More actions

  September 19, 2008 at 7:54 am

  #123631

  Hi

  I am trying to get data from the following web service

  http://www.webservicex.net/stockquote.asmx?wsdl

  I cant understand how to use SSIS to get this data.

  Thanks

• 0x30

  SSC Veteran

  Points: 299

  More actions

  September 23, 2008 at 5:36 am

  #875564

  This article http://msdn.microsoft.com/en-us/library/ms140114.aspx may help point you in the right direction.

  Also http://zulfiqar.typepad.com/zulfiqars_web/2006/11/ssis_web_servic.html or http://aspalliance.com/1167_A_StepbyStep_Approach_to_Creating_a_Web_Service_Task_Using_SQL_Server_Integration_Services.all.

  Hope this helps!

• Prachi-885067

  SSC Veteran

  Points: 218

  More actions

  September 23, 2008 at 6:39 am

  #875594

  If you want call the web service inside Data Flow Task then you need to create its web proxy and then use web proxy in Script component.

  If you need to call web service only once(i.e. not for individual row inside data flow task) you can use Web Service Task in Control Flow.