SSIS conditional delimiter does not work as intended

Question

I have an SSIS job as follows:

The separation is as follows:

Search Settings:

I only look against ticketId in both sources / destinations.

The problem is that out of 2288, many should be new rows that are not in the destination database, but it looks like they all go into an update state.

What could be the problem?

Answer 1

Yes, it is looking for the original TicketID, you will need to get the TickedID out of the search, and then check it for NULL.

After that you need to change the conditions:

• ISNULL (LKP_TicketId)
• ! ISNULL (LKP_TicketId)

@Jayvee , .

Answer 2

. , .

Answer 3

Conditions must be clearly stated, this conversion considers all Ticketid instead of case approval. SO writing everything in the direction of updating

1) isnull(TicketID) != isnull(TicketID)  -- record not exists

2) isnull(TicketID) == isnull(TicketID)  -- Record exists