title: Performing a slow update with SSIS
body: <p>I have a raw file that contains 2m rows ; an ID and a text column</p>
  
  <p>What I want to do is use this raw file and update a table on our live database. The problem I have is I want this to happen in batches/slowly as I dont want to impact live too much whilst it is doing this. </p>
  
  <p>The process will need to open the raw file using a Dataflow task and then for each row update the table one row at a time matching on the id . Can I get a dataflow task to pause in some way ?</p>