title: SSIS - Can you use a parameterised query to populate a Lookup Transformation?
body: <p>I am using a stored procedure to populate a Lookup Transformation, but would like to restrict the size of the lookup cache.  </p>
  
  <p>I could do this by supplying a parameter to the stored procedure, but I can't see any way of parameterising the query on the Lookup Transformation component.</p>