Hands-On-Lab: 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.

Exercise 1: Use Web Service Task to call the Web Service from SSIS
Exercise 2: Use Script Component to call the Web Service in SSIS

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.