title: Loop Control within a DataflowTask in ETL
body: <p>Being fairly new to SSIS and the ETL process, I was wondering if there is anyway to loop though a record set within a DataFlowTask and pass each row (deriving parameters from the row) into a Stored Procedure (the next step in the ETL phase). Once i have passed the row into the stored procedure, I want the results from each iteration to be written to a Table.
  Does anyone know how to do this?</p>
  
  <p>Thanks.</p>