Join two outputs of conditional split in one output in SSIS

Question

Hello, People.

I have a Merge Join output (Combinación de Mezcla 10). Here come a set of data. I used a Conditional Split to take out some rows (Case 1), aggregate them and sort them. The other output from Conditional Split (Conditional Split Default Output), I am taking them to a merge join (I used a virtual column to join the two set of data in the Merge Join 1). When I am trying to take join the Merge Join 1 with a derived column (Columna derivada 13), I got the error below. What is that? I just want to continue with my flow in one output.

Regards,

Thanks in advanced.

Answer 1

Hi @Geraldo Peralta

From my opinion, the Merge Join1 could not connect to the derived column, it's unreasonable.

You can not use one derived column for different outputs from two sides.

Add a new derived column under Merge Join1 and then you may connect to the other Merge join as you need.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.