Consume SOAP web serice in SSIS

rajanisqldev-42 206 Reputation points
2021-05-13T12:15:49.117+00:00

Hi

I have SOAP webservice given by third party client.

I need to consume in SSIS and pull data into sql db

I am trying to use Webserive task. I have given the wsdl url and downloaded the wsdl file. But I couldn't see any methods in the input tab.

Is there any other way to consume SOAP webservice in SSIS?

Regards

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,403 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points
    2021-05-14T02:18:23.097+00:00

    Hi @rajanisqldev-42 ,

    Here are some examples for your reference.

    calling-soap-web-service-in-ssis-xml-source

    consume-a-soap-web-service-with-ssis

    Hope it could give you some ideas.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments

  2. rajanisqldev-42 206 Reputation points
    2021-05-14T09:07:58.403+00:00

    Hi Zoehui-MSFT,

    Thanks for the reply but we don't want to buy third party licences.

    Regards