ssis

Consume a Web Service in SQL Server Integration Services
In this post, we will see how to consume a webservice in ssis using Web Service Task Using Web Service Task Web Service Task is used to execute Web Method. We can get the value returned from the web service, assign it to a variable and later use it in ssis package. This can also be used to get a list of available values, store it into a file and use that file as a data source for the package. This task is available as a control flow task; when dragged and dropped onto design area we need to

Blog Content