Script JSON Transformation
Data flow transformation to retrieve data from column containing array with JSON objects.
The script has the following parameters:
- DataColumn - specifies column containing JSON array.
- IncludeSequenceTerminator - specifies if an empty row will be added to output after the processing of an input row. This is useful when input rows contain arrays of multiple JSON objects, e.g. in the context of SSIS+ support for composite records.
- Sample - sample JSON to initialize metadata. It would be used for the creation of output columns. If the sample is changed the output columns will be deleted and created again.
In this quick-start we will setup a JSON Transformation.
Providing sample data
The format of the sample data is array of JSON objects. All objects are processed and from their properties the output columns are created. The columns are created immediately after changing value of the parameter. If "Sample" is changed the current output columns are deleted and the new are created.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.