Is there a WHERE function in SSIS for a flat file file?

Question

I don't know much about SSIS, and I searched as much as I could. I would really appreciate any help I could get.

I am creating an SSIS package and I only want to insert a specific dataset from the Flat File Source file. Is there a way to use the WHERE clause to pull only certain data?

For example, how can I make this request in a data flow task?

INSERT INTO #TempTable (Column1, Column2) SELECT Column1, Column2 FROM TEXTFILESOURCE WHERE Column1 <> 'ABC' 

Can this be achieved using a data flow task?

Answer 1

AFAIK there is nothing in the Flat File Source task that can do this, but once you have this setting and the data you enter, you can use the conditional delimiter to filter the lines using the same logic as your condition Where is your request.