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

There are currently ten SSIS components available in the HTTP/Web Service category, including three connection managers (OData, HTTP, and Web Service), two HTTP Requester components (a data flow component and a task component), a Web Service task component, two source components (OData and Web Service), and two destination components.

Listed below are the HTTP/Web Service components available within the SSIS Productivity Pack and links to their Help Manuals:

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

JSON & XML Processing Components

In addition to the above, the SSIS Productivity Pack comes with a full suite of JSON & XML processing components which can utilize the same HTTP connection infrastructure in order to facilitate data integration through either REST or SOAP service endpoints with easy.

JSON Components

  • JSON Source
    • An SSIS source component used to retrieve JSON documents from an HTTP URL or a local file. The components will then break up the structure and produce column data which can be consumed by downstream SSIS pipeline components.
  • JSON Extract
    • A transformation component that receives a JSON document from an upstream component and extracts data to produce column data for the SSIS pipeline.
  • JSON Merge
    • An SSIS transformation component used to take incoming data from upstream SSIS source components and merge them into one SSIS column data based on the JSON data structure defined in the component.
  • JSON Destination
    • An SSIS destination component used to merge input data based on the JSON data structure defined in the component. You can then specify the component to write the merged JSON document to a local file or you can send it to a HTTP URL to perform a RESTful service call.

XML Components

  • XML Source
    • An SSIS source component used to retrieve XML documents from an HTTP URL or a local file. The components will then break up the structure and produce column data which can be consumed by downstream SSIS pipeline components.
  • XML Extract
    • An SSIS transformation component that receives an XML document from an upstream component and extracts data to produce column data for the SSIS pipeline.
  • XML Merge
    • An SSIS transformation component used to take incoming data from upstream SSIS source components and merge them into one SSIS column data based on the XML data structure defined in the component.
  • XML Destination
    • An SSIS destination component used to merge input data based on the XML data structure defined in the component. You can then specify the component to write the merged XML document to a local file or you can send it to a HTTP URL to perform an XML or SOAP-based service call.

HTML Components

  • HTML Table Source
    • An SSIS destination component used to retrieve an HTML document from an HTTP request or a local file and extract a table element into column data.

Video Resources

Youtube Video - Getting started with SSIS Productivity Pack - JSON Processing

Youtube Video - Getting started with SSIS Productivity Pack - XML Processing