In this tip, we will learn how to work with Web Services using SQL Server Integration Services (SSIS). We will use a simple example to call a web service from SSIS and store the results in a file. Solution. A web service is a method over the network used to share information between applications.
Web Services is a way of marshalling procedure calls across the Internet. Of course, you don't have to use Web Services with the Internet; you can use Web Services within the same application or across any other network. It just happens that the Internet is the most important environment that Web Services target. Until recently you used DCOM to.