3

Resolved

DT_DBTIME2 support

description

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?
 
Thanks,
 
Alex

comments

toddmcdermid wrote Aug 21, 2010 at 6:37 PM

Yep - handling was incomplete.