JSON & XML Processing Components

JSON and XML Processing Components

We offer SSIS components that enable developers to efficiently process JSON, XML, and HTML data within SSIS pipelines. The JSON and XML Processing Components offer functionalities such as retrieval, extraction, merging, and destination writing for various data sources and structures.

The following are the help manuals for JSON and XML Processing Components available in the SSIS Productivity Pack:

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