SSIS(Kingswaysoft):Two different metadata sources into single destination

Question

Is it possible to have flatfile and JSON source as inputs to a JSON destination?

Answer 1

If you want the two sources merged side-by-side, use the the Merge Join Component to merge the two sources into one before reaching the destination.

If you want them merged vertically, use the Union All component.

Answer 2

I would like to clarify, using our JSON Merge or JSON Destination component (I work for KingswaySoft), we can merge the results from more than one SSIS inputs. You don't need to pre-merge using a Merge Join component or something in that nature. There is a reason that we call the component a JSON Merge component. :)

I hope this makes sense, please let me know if you need any further assistance on this.