Maybe a too simple solution and you have been that way, but I see as a workaround :

1) lookup on

the DataStagingSource.NaturalKey = DataWarehouseDimension.NaturalKey

and include in the lookup the following columns :

• DataWarehouseDimension.RowExpiredDate 
• DataWarehouseDimension.RowEffectiveDate

2) feed that output into a conditional switch, which contains the logic of

DataStagingSource.ModifyDate < DataWarehouseDimension.RowExpiredDate AND  DataStagingSource.ModifyDate >= DataWarehouseDimension.RowEffectiveDate

On the output you should have only the records which apply to your conditions.

Hope this is usefull.

- Servaas