1
Vote

scdExpireDate woes. Want to manage my own...

description

I love this tool!
I have a source table that already tracks the begin date and the end date of an employee's status (along with a bunch of other employee information). I want to use the tool for scd1 and scd2 type changes but I'd like to use my source table's begin/expire dates. Is this possible or is there something here I'm not catching.

comments

smadirondack wrote Dec 12, 2011 at 8:26 PM

I should mention that I have tried to change the scdExpireDate with an OLE Command for "new" rows. It ignores the parameter that I use to set that column. All the new rows have null in the scdExpireDate.


INSERT INTO [SPBI].[dbo].[DimGeneralManagers]
       ([departmentId]
       ,[firstName]
       ,[lastName]
       ...
       ,[scdBeginDate]
       ,[scdExpireDate])
 VALUES
       (?
       ,?
       ,?
       ...
       ,?
       ,?)

Sign in to add a comment or to set email notifications