title: SSIS: enrich query and table with input file as base
body: <p>I need to extract data from a DB2 database to a SQL Server. I need to create my query based on a Excel file I have 176 records, which I need to create repeating queries &amp; put in SQL server
  So for example;</p>
  <p>I have an Excel with a Number, From date, To date, and a Country
  So the query should use these information from the records</p>
  <pre><code>SELECT *
  FROM dbo.Test
  WHERE Number = excel.Number1 AND Date BETWEEN excel.fromDate1 AND excel.toDate1 AND Country = excel.country1
  </code></pre>
  <p>And then another query with</p>
  <pre><code>SELECT *
  FROM dbo.Test
  WHERE Number = excel.Number2 AND Date BETWEEN excel.fromDate2 AND excel.toDate2 AND Country = excel.country2
  </code></pre>
  <p>Etc...</p>
  <p>How should I do something like this in SSIS?</p>
  <p>If needed I can put the DB2 and Excel data in MS SQL</p>