Calling Web Service From SSIS

In this lab, we’ll learn how to call a web service from SSIS. In the first exercise, we will learn how to use SSIS inbuilt component Web Service Task to call the Web Service and get the data in XML format from Web. In second exercise, we will learn how to use the Script Component to call the Web Service from SSIS and get the response from Web Service.