Is there a setting to enforce case sensitivity when setting the Logical Key Field to be used in type 2 SCD.

This message has been edited. Last edited by: <Kathryn Henning>,

It turns out our SQL Server database default collation was set so that it was case insensitive. I've reolved this issue by making a database change. i.e. changining the COLLATION to Latin1_General_CS_AS