I have an SSIS job as follows:

[![enter image description here](https://i.stack.imgur.com/g3pK8.png)](https://i.stack.imgur.com/g3pK8.png)

The split is as follows:
[![enter image description here](https://i.stack.imgur.com/qH9gp.png)](https://i.stack.imgur.com/qH9gp.png)

Lookup settings:
[![enter image description here](https://i.stack.imgur.com/e9yde.png)](https://i.stack.imgur.com/e9yde.png)

[![enter image description here](https://i.stack.imgur.com/T2p3h.png)](https://i.stack.imgur.com/T2p3h.png)

I'm only looking against the ticketId in both source/destination.

The issue is that out of the 2288, many should be new rows which don't exist in the destination DB but it seems like they all go to the Update condition instead.

What can be the issue here?