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.
#kingswaysoft
JSON SOURCE COMPONENT
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 MERGE COMPONENT
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 COMPONENT
An SSIS destination component used to merge input data based on the JSON data structure defined in the component. You can then specify whether to write the merged JSON document to a local file or send it to an HTTP URL to perform a RESTful service call.
JSON EXTRACT TASK COMPONENT
An SSIS control flow task component that can be used to send an HTTP request and receive a response.
Learn more at https://www.kingswaysoft.com/products/ssis-productivity-pack/help-manual/json-and-xml-processing
