JSON Processing Components in the SSIS Productivity Pack - Get Started скачать в хорошем качестве

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. You can learn more about these components from the help manual: http://www.kingswaysoft.com/products/... The components along with all others found within the SSIS Productivity Pack are available for download here: http://www.kingswaysoft.com/products/... Visit the following link to learn more about the SSIS Productivity Pack, a collection of premium, powerful and unique SSIS components every developer needs in their toolbox: https://www.kingswaysoft.com/products... This video was made with v4.1 of the SSIS Productivity Pack. #json #dataintegration #ssis