title: Is there a WHERE Clause feature in SSIS for a Flat File Source?
body: <p>I don't know too much about SSIS and I've googled as much as I could on this. I'd really appreciate any help I could get.</p>
  
  <p>I'm building an SSIS package and I only want to insert a specific set of data from a Flat File Source. Is there a way to use a WHERE clause to only pull specific data in?</p>
  
  <p>For example, how can I make this query into a Data Flow Task?</p>
  
  <pre><code>INSERT INTO #TempTable (Column1, Column2)
  SELECT Column1, Column2
  FROM TEXTFILESOURCE
  WHERE Column1 &lt;&gt; 'ABC'
  </code></pre>
  
  <p>Can this be achieved through Data Flow Task?</p>