If you want to filter – reject records during a Microsoft SQL Server Integration Services (SSIS) import of a flat file, you can use the Conditional Split Data Flow Transformation. If the flat file is a CSV file with the following contents:

Flat file contents

EEEtest,0,1,2

000000,0,1,2

blabla test,0,1,2

Result

EEEtest,0,1,2

blabla test,0,1,2

One row is filtered, because the first column has a value of “000000” and thus starts with “0000”, see the Condition expression

Complete dataflow screendump