title: SSIS Lookup Transform use Table or Query
body: <p>I have a Lookup Transformation on a table with 30 columns but I only am using two columns: ID column for the join and Update column as Output.</p>
  
  <p>On the connection should I enter a query <code>Select ID, Update From T1</code> or Use Table in the drop down?</p>
  
  <p>Using table in Drop down would this be like doing <code>Select * From T1</code> or is SSIS clever enough to know I only need 2 columns.</p>
  
  <p>I'm thinking I should go with the Query <code>Select ID, Update From T1</code>.</p>