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.
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
