HTTP/Web Services components are SSIS components which facilitate working with HTTP and SOAP or REST-based web services within SSIS.

There are currently nine SSIS components that fall under the HTTP/Web Service category; two connection managers, two HTTP Requester components (a data flow component and a task component), two OData components (as Source and Destination) and a Web Services Source, Destination and Task components.

The following are the HTTP/Web Service components available within the SSIS Productivity Pack and the link to their Help Manuals:

Youtube Video - Getting started with SSIS Productivity Pack - HTTP Web Services Components

  • HTTP Connection Manager
  • HTTP Requester
    • An SSIS data flow component which can be used to send a series of HTTP requests and process their response.
  • HTTP Requester Task
    • An SSIS control flow task component which can be used to send an HTTP request and receive a response.
  • Web Service Source
    • With this component, developers can retrieve data from virtually any SOAP based service endpoint using a WSDL file.
  • Web Service Destination
    • This SSIS component supports writing data to virtually any SOAP based service endpoint using a WSDL file.
  • Web Service Task
    • An SSIS task component which can be used to read/retrieve data from a web service.