Extract even product ID in one file and odd product ID in another file using Conditional split transformation

The Conditional Split transformation can route data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is similar to a CASE decision structure in a programming language. The transformation evaluates expressions, and based on the results, directs the data row to the specified output. This transformation also provides a default output, so that if a row matches no expression it is directed to the default output.

ReadMore about Conditional Split Transformation

http://bageshkumarbagi-msbi.blogspot.com/2014/12/conditional-split-transformation-in-ssis.html

We have a product table and our requirement is to extract the data from this table and write it into two CSV files. Even product ID into the even file and odd product file into the odd file.

 

Let’s see the demo

Taking Data Flow task and taking OLEDB Source

  

Now I am taking Conditional split Transformation.

  

Now I am taking two flat file destination.

 

Now my package is ready to run.

Before running this package files in the destination table.

Running this package.

See the destination folder.

  

File data