title: SSIS type 2 scd with batch ID
body: <p>I want to modify standard SSIS SCD behavior.</p>
  <p>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.</p>
  <p>BatchLogID is passed to dataflow as an int</p>
  <h2>EmployeeID,title,firstname,lastname,BatchLogID,startdate,enddate</h2>
  <p>source data</p>
  <p>101,Miss,Jane,Smith,101 -- inserted for first time</p>
  <p>101,Miss,Jane,Smith,102 process runs</p>
  <p>101,Miss,Jane,Smith,103 process runs</p>
  <p>101,Miss,Jane,Smith,104 process runs</p>
  <p>101,Mrs, Jane,Brown,105  process runs -- only when data has changed do I want the Batch number in target updated</p>
  <p><strong>target data</strong></p>
  <p>101,Miss,Jane,Smith,101,101,1 jan 2000,null-- inserted for first time</p>
  <p>101,Miss,Jane,Smith,105,105,1 jan 2000,5 Jan 2000 -- as a change is detected the data is updated</p>
  <p>101,Mrs, Jane,Brown,105,105 jan 2000,null-- only when data has changed to I want the Batch number updated</p>
  <p>any thoughts?</p>