How to filter – reject records during Microsoft SQL Server Integration Services (SSIS) import of a flat file

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

 

image

 

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

image

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *