title: SSIS - Loop through multiple data source data
body: <p>Im very new to SSIS. I have the following scenario
  I receive a dataset from SourceA through a Execute SQL task -each row has 3 columns - ColumnA,Column b,Column C</p>
  
  <p>I have a second data source(source 3) which would return Column D for each column C in previous dataset.</p>
  
  <p>Once I recieve this data, I need to map/store Column A and Column D to be stored into out local DB(Source 3).</p>
  
  <p>Can you give me a high level idea on how to proceed.</p>