Is there a WHERE Clause feature in SSIS for a Flat File Source?

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.

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?

For example, how can I make this query into a Data Flow Task?

INSERT INTO #TempTable (Column1, Column2)
SELECT Column1, Column2
FROM TEXTFILESOURCE
WHERE Column1 <&开发者_JS百科gt; 'ABC'

Can this be achieved through Data Flow Task?

AFAIK there is nothing in the Flat File Source task that can do this, but once you have that set up and the data flowing in, you can use a Conditional Split to filter the rows using the same logic as your Where condition in your query.

Either a conditional split, with your filter conditions as an expression, or, a script task using C# but that would be an overkill if the flat file data is consistent enough you could just use conditional split.