CODEWITHSUNDEEP
ssiskingswaysoft
kanna
kanna

Reputation: 73

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

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

Upvotes: 0

Views: 402

Answers (2)

Daniel Cai
Daniel Cai

Reputation: 446

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.

Upvotes: 2

Tab Alleman
Tab Alleman

Reputation: 31785

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.

Upvotes: 0

Related Questions