title: SSIS fuzzy lookup (lookup agains valid range of values)
body: <p>I was wondering if anyone had a good solution to trying lookup a value against a range of values in a fuzzy lookup transformation.</p>
  
  <p>By "range of values" I mean either a date range such as start and end dates in the lookup table or comparison range such as a high and low value of house numbers compared to the exact house number in a record.</p>
  
  <p>Or if there is solution how to solve fuzzy lookup against only valid values by condtion. </p>
  
  <p>Iam using ssis 2008</p>
  
  <p>Example: </p>
  
  <h2>My sales data example:</h2>
  
  <pre>
  ID   Product    Quatity      date 
  1    Product1   1            1.2.2015
  2    Produc?t1  1            1.2.2015
  3    Produt1_   1            10.7.2015
  </pre>  
  
  <h2>My price list</h2>
  
  <pre>
  ID    Name      Price     ValidFrom     ValidTO
  1     Product1  10        1.1.2015      28.2.2015
  2     Product1  11        1.3.2015      null
  </pre> 
  
  <p>My sales data are kind of dirty (sources are various) - that's why I want to use FUZZY lookup.</p>
  
  <p>I want to fuzzky lookup againts my price list but only against valid prices.</p>
  
  <p>So after lookup result should look like this</p>
  
  <pre>
  ID   Product    Quatity      date       Price
  1    Product1   1            1.2.2015   10
  2    Produc?t1  1            1.2.2015   10
  3    Produt1_   1            10.7.2015  11
  </pre>
  
  <p>But if I use fuzzy I cannot specify the condition before I use fuzzy lookup.</p>
  
  <p>Thanks in advance,
  Martin</p>