When you modify a single record in a row several times in a CDC source, enable the

Preserve record order on write

option in the advanced write operation property to retain the order number of the changed record when you write the changed record to the target table.

For example, you have a record in the following CDC source table in which you have performed multiple of operations:

Emp ID	Emp Name	Emp Description	RowType	RowID
1	John	L1	Insert	1
1	John	L2	Update	2
1	John	L3	Update	3

Here, assume that the

RowID

shows the order of the changed record in the CDC source table.

The Data Integration Service writes the following changed record along with the order number in the target table:

Emp ID	Emp Name	Emp Description	RowType	RowID
1	John	L3	Update	3