There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
The KSCD seems to support the new time data type (in sql server 2008) when in design mode, however when you run the package the component errors.
[MSC_SCD ClaimDetail] Error: Internal error (Unsupported Data Type for comparison: DT_DBTIME2) in ProcessKey, detecting SCD1 and 2 changes in column TimeOfLoss, key: ffffffffffffffff.
Looking at your code the method CompareFields doesn't cater for DT_DBTIME2. Is this by design?