What is the difference between two keep identity in oledb destination

ssis

Solution

I assume you are talking about the difference between OLE DB Destination Editor

and the corresponding property?

They are the same thing. The second image is what is serialized out in the XML from the object while the former is BIDS/SSDT's representation of those properties. You can verify this by turning either one on or off and observing the same change is mirrored in the other.

Generally speaking, the Properties of an object in SSIS will always show you the unvarnished truth but the listed items may not always be useful or well named. For those items, the SSIS team generally provides customized editors to address or configure components.

Problem

Original source