ssiskingswaysoft

JSON Extract : Output upstream columns in JSON array node

I use JSON Extract from the SSIS library KingswaySoft to parse a JSON content.

From the root JSON, I can output the input columns (named upstreams) : enter image description here

But it don't look possible from a array node : enter image description here

How can output the input columns in the array node output?

Solution

  • It seems that the upstream is only available on the root output. The solution is to merge the node array output with root output.

    In the node array output add the _ParentKeyField : enter image description here

    This column take the value from root's column specify in "Output Settings" (by default _RowIndex) : enter image description here

    The merge need the output to be sorted. Open the JSON Extract with "Show Advanced Editor...". In the tab "Input and Output Properties", set the property IsSorted to true for the output "Root" and " : enter image description here

    Set the property SortKeyPosition to 1 for :

    In the flow, add the a "Merge join" and redirect the root output to left join and the node array output to right join. Configure to join on "_RowIndex=_ParentKeyField" : enter image description here

    Finally, you can select the desired column : enter image description here