I want to modify standard SSIS SCD behavior.

EmployeeID is my business key and title, firstname, lastname are type 2 attributes.
I want BatchLogID to reflect when a change occurred - otherwise it remains unchanged.

BatchLogID is passed to dataflow as an int

EmployeeID,title,firstname,lastname,BatchLogID,startdate,enddate
----------------------------------------------------------------

source data

101,Miss,Jane,Smith,101 -- inserted for first time

101,Miss,Jane,Smith,102 process runs

101,Miss,Jane,Smith,103 process runs

101,Miss,Jane,Smith,104 process runs

101,Mrs, Jane,Brown,105 process runs -- only when data has changed do I want the Batch number in target updated

**target data**

101,Miss,Jane,Smith,101,101,1 jan 2000,null-- inserted for first time

101,Miss,Jane,Smith,105,105,1 jan 2000,5 Jan 2000 -- as a change is detected the data is updated

101,Mrs, Jane,Brown,105,105 jan 2000,null-- only when data has changed to I want the Batch number updated

any thoughts?