SCD1 Deleted in v1.6, almost works but an error

Topics: Possible Bugs/Missing Features?
Nov 21, 2010 at 9:41 AM

I was trying to test v1.6's handling of the deleted output for SCD1 only and received the following errors:

Error: 0x0 at Data Flow Task 1, Kimball Method Slowly Changing Dimension: Internal error (Object reference not set to an instance of an object.) ProcessCache_SendExistingToDeleted setting SCD2 dates, key: 3100300030003000.
Error: 0x0 at Data Flow Task 1, Kimball Method Slowly Changing Dimension: Internal error (Internal error (Object reference not set to an instance of an object.) ProcessCache_SendExistingToDeleted setting SCD2 dates, key: 3100300030003000.) ProcessCache_SendExistingToDeleted key: 3100300030003000.
Error: 0x0 at Data Flow Task 1, Kimball Method Slowly Changing Dimension: Internal error (Internal error (Internal error (Object reference not set to an instance of an object.) ProcessCache_SendExistingToDeleted setting SCD2 dates, key: 3100300030003000.) ProcessCache_SendExistingToDeleted key: 3100300030003000.) in ProcessKey, case 3 - Unchanged, key: 3100300030003000.
Error: 0x0 at Data Flow Task 1, Kimball Method Slowly Changing Dimension: Internal error (Internal error (Internal error (Internal error (Object reference not set to an instance of an object.) ProcessCache_SendExistingToDeleted setting SCD2 dates, key: 3100300030003000.) ProcessCache_SendExistingToDeleted key: 3100300030003000.) in ProcessKey, case 3 - Unchanged, key: 3100300030003000.) in ProcessKey detecting changes, key: 3100300030003000.
Error: 0x0 at Data Flow Task 1, Kimball Method Slowly Changing Dimension: Internal error (Internal error (Internal error (Internal error (Internal error (Object reference not set to an instance of an object.) ProcessCache_SendExistingToDeleted setting SCD2 dates, key: 3100300030003000.) ProcessCache_SendExistingToDeleted key: 3100300030003000.) in ProcessKey, case 3 - Unchanged, key: 3100300030003000.) in ProcessKey detecting changes, key: 3100300030003000.) in ProcessCache_Thread_ProcessKey.
SSIS package "merc_export_vx.dtsx" finished: Canceled.

 

There are 1955 records in the existing table and 1953 in the source table.  The Deleted destination is a Recordset object capturing all input columns.  All columns including the business key are DT_WSTR.   It seems it should have routed the 2 deleted items properly but crashes out with the above errors.  

If I disconnect the Deleted output and ignore unconnected output the process finishes properly, even noting the 2 Deleted items.  This means they are no longer sent to Unchanged, which is great, but how can I gain access to the Deleted rows?

Any thoughts?  It appeared that v1.6 had addressed this but either I'm doing something wrong (highly possible) or there is still a bug/unimplemented feature.

Thanks,

Chris

Coordinator
Nov 23, 2010 at 3:35 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.