Using web services in ssis to get data from api

Question

Hi everyone,

I am trying to get data from this api in ssis and got the following error;

**TITLE: Web Service Task

Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following error occurred while reading the file. There is an error in XML document (0, 0)..

BUTTONS:
OK
------------------------------**

Answer 1

Hi @Anonymous ,

1.Please create an empty WSDL file firstly.

2.Then set OverwriteWSDLFile as True and click Download WSDL in the General page of Web Service Task.

3.Set the Input and Output .

4.Please refer to the following links and pictures:

Web Service Task-WSDL File

Example using Web Services with SQL Server Integration Services

Best Regards,
Mona

---

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.