JSON & XML Processing components are SSIS components used to interact with JSON or XML data.

There are currently nine components available within this category:

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 (Component)
    • A transformation component that receives a JSON document from an upstream component and extracts data to produce column data for the SSIS pipeline.
  • JSON Extract Task
    • An SSIS control flow task component that can be used to send an HTTP request and receive a response.
  • 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 an 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 (Component)
    • 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 Extract Task
    • An SSIS control flow task component that can be used to send an HTTP request and receive a response.
  • 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 an HTTP URL to perform an XML or SOAP-based service call.

HTML Components

  • HTML Table Source
    • An SSIS source 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