Consuming a WSDL in SSIS

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » Consuming a WSDL in SSIS

Consuming a WSDL in SSIS

Topic RSS Feed

Posts under the topic: Consuming a WSDL in SSIS

Posted: 2/10/2012

Jedi Youngling 12  points  Jedi Youngling
  • Joined on: 12/6/2009
  • Posts: 6

I am currently working with a WSDL that I would like consume with SSIS.  I'm not able to get the Web Service Task to work properly, so I have created a Script Task.  I successfully added the web reference, and I can see the data elements I want to consume when I go to Object Explorer.  I'm just not clear on next steps.  It looks like I need to write some code, but I'm not sure what exactly it needs to accomplish.

Derek


tags wsdl

Posted: 2/13/2012

Jedi Master 5325  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 298

Why not use the built in web service task?


Posted: 2/13/2012

Jedi Youngling 12  points  Jedi Youngling
  • Joined on: 12/6/2009
  • Posts: 6

Mike,

I followed the example in your post for the Web Service Task, and I was able to get that to work.  However, when I updated the task for the SAP service I'm trying to consume, I did not see any methods.  So, based on my online research, it seemed the Web Service Task wouldn't work for this particular service, and a Script Task is in order.

Thank you.

Derek


Page 1 of 1 (3 items)