How to pass user credentials to WSDL (web service) inside script task/SSIS?

Question

Requirement -I have user credentials to access a WSDL file and I can access the file via browser.

WSDL link - XYZ
userdID- asdf
pwd - *****

I need to use C# code inside SSIS script task to call this web service (specifically a single method call) using appropriate user credentials.

Get the response(which would be in XML) , parse the XML to get specific values from it and insert that into a SQL table.

If anyone know/have any idea/reference link on how to achieve the above requirement, please let me know.

score 2 · Answer 1 · answered Jan 14 '19 at 19:13

Using SSIS there are two methods to call a Web service.

Using SSIS Web Service Task

I think this is more preferable.

You can create an HTTP connection Manager and specify the credentials then use it in Web Service Task, you can refer to the following link for detailed example:

Example using Web Services with SQL Server Integration Services

Also there are more helpful links that you can refer to:

Using C# Script

You can refer to one of the following links for more information:

@GowthamRamamoorthy i will be waiting for your feedback – Hadi Jan 14 '19 at 20:04 — Hadi, Jan 14 '19 at 20:04
@GowthamRamamoorthy anything new?? – Hadi Jan 27 '19 at 20:15 — Hadi, Jan 27 '19 at 20:15

How to pass user credentials to WSDL (web service) inside script task/SSIS?

1 Answers1

Using SSIS Web Service Task

Using C# Script

Linked