Interacting SSIS with Web Service

By: Kasim Wirama, MCDBA, MVP SQL Server
Other interesting component of SSIS is web service component as interface to interact with other third party through web service.
You can build your own web service with Visual Studio, then you can create your SSIS project by first creating HTTP connection manager. Specify server url in HTTP connection manager editor window. Then you drag web service task into control flow designer, on general page, select http connection manager on HttpConnection property, type wsdl file for saving into your local SSIS, and specify whether you would like to override the wsdl file.
On input page, you can select service name and web service method. And on output page you can receive web service output to any destination such as to variable or to file.
You can test your SSIS package, when check that the output will be saved into your specified destination.