Change Capturing....

[Adam_Clone]

What are "edit and copy" changes as relevant to change capture stage...
Is it changes to any column values. If it is so, then there appears to be a problem. It is not capturing changes made to any columns...And change code 0 stands for copy if I'm right. Is it ? Is copy just the copy of the unchanged rows ?

[vmcburney]

Copy indicates the comparison rows on the before and after rows were exactly the same and if you set the copy flag to true it will copy the after rows to the output link. Edit indicates a matching rows was found based on the key fields but some of the comparison value fields were different.

Identifying an edit depends on what Value rows you have chosen. The "Change Mode" Option defines your values fields. "Explicit Keys All Values" means you define the key fields to do the join and the comparison occurs on all other fields. "Explicit Keys & Values" lets you define key fields and define value fields so you do not have to compare the entire record, useful if you know some of your fields do not make it all the way into your target.