JSON Source / Destination SSIS components for parsing JSON files and generating of JSON files.

Timeline:
0:00:00 JSON demo introduction
0:01:25 JSON Source component
0:05:35 JSON Destination component

The JSON SSIS integration package consists of:

⭐ JSON Source component - Reads and parses JSON from a variable, file or direct text.
⭐ JSON Transformation script - Extract structured data from a text column that stores arrays with objects in JSON. An optional transformation function is used to convert a raw array to JSON array.
⭐ JSON Destination component - Generates a JSON data.

✔️ Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019