JSON Processing Components in the SSIS Productivity Pack - Get Started

0:00 Introduction
1:52 JSON Source Component
7:54 JSON Extract Component
13:18 JSON Merge Component
19:19 JSON Destination Component
28:49 Conclusion

The JSON Processing Components components are SSIS add-on components from the SSIS Productivity Pack which facilitate extracting a JSON structure into column data or merging column data into a JSON structure.

We currently offer the following 4 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 that 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 an HTTP URL to perform a RESTful service call.

This video was made with v4.1 of the SSIS Productivity Pack.
#json #dataintegration #ssis

[pkislansky]

Hi
"total_pages" ?? Where is this comming from?