The data-flow from the JSON Source Component after being sent through a Sort transformation component will hang indefinitely when connected to a Merge Join transformation component. The Sort works fine until you attempt to connect it with a Merge Join. When attempting to Debug the process will load indefinitely at this stage and no data will move through the Sort and Merge Join. When attempting to move the data directly into a table "Not using a Merge Join" the process works fine.
The data-flow from the JSON Source Component after being sent through a Sort transformation component will hang indefinitely when connected to a Merge Join transformation component. The Sort works fine until you attempt to connect it with a Merge Join. When attempting to Debug the process will load indefinitely at this stage and no data will move through the Sort and Merge Join. When attempting to move the data directly into a table "Not using a Merge Join" the process works fine.
Thank you