Populating A Surrogate Key Inside Data Flow Task

Hi,



I have tables like the one below for my Stage and dimension tables:



Stage Table

accountid

name

address





Dimension Table

accountkey ---- surrogate key (DW key)

accountid ---- business key (transaction's primary key)

name

address



I used slowly changing dimension to detect the changes for the records inside my Dimension table. But I had a problem when a new record exists in the stage table. The accountkey is set as the primary key and it gets its value from a different table which stores the last account key that was created. I cannot load all the changes unless i have a business key. Is there a way that i can get the "last key" from a different table in the data flow area and then supply it together with the other fields in the new output branch of the slowly changing dimension?



cherriesh



thanks!