DT_DBTIME2 support

Jul 12, 2010 at 4:02 PM
Edited Jul 12, 2010 at 4:15 PM

Hi Todd

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

Coordinator
Jul 16, 2010 at 4:32 PM

Thanks for digging into the code - I'll take a peek and see what I can find...

Coordinator
Jul 16, 2010 at 4:33 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.