title: How to pass a variable to an SSIS package to be used in query
body: <p>I'm currently having an issue when trying to import data using SSIS.
  I have an SSIS package that moves data from one server / database to another server / database.
  At the moment the query will take all rows in the source DB and move it to the destination.
  I need to change this so that only a select few rows are moved using the ID as the filter.
  I need to pass an ID in as a parameter which is to be used to filter the dataset to only return the select few rows. How does one do this?
  I currently have a simple SSIS package with 2 dataflow objects (source &amp; destination) but from what I've been looking at I may need to change this somewhat.</p>
  
  <pre><code>SELECT 
  ID, 
  [Product Type], 
  [Product Title]
  FROM [View]
  where ID = &lt;This should be provided from outside the package&gt;
  </code></pre>
  
  <p>The package will eventually be triggered by TSQL / Stored Procedure.</p>
  
  <p>Thanks.</p>