title: SSIS CDC Control Task
body: <p>Am doing a proof of concept for usage of SSIS CDC component.</p>
  
  <p>For initial load:  What I got so far is </p>
  
  <p>step 1: CDC Control Task with CDC Control Operation as : Mark Initial load start
  step 2: Data flow to load all source records to destination 
  step 3: CDC Control Task with CDC Control Operation as : Mark Initial load end (rest of setting as of CDC in Step 1)</p>
  
  <p>When I run first time ... all data loads fine.
  If run the same ... instead picking none records (no change in source)  ... its reloads all the records again ... duplicating.</p>
  
  <p>Does this doesn't check in CDC State table created in step 1.</p>
  
  <p>Anyone can point me to good sample or tutorial would be great.</p>