Today we will learn on how to use Conditional split task available within SSIS to split the out from the source data
- Drag a conditional split task in the SSIS and attach it to your source
- Open the expression editor for Conditional split
- Create two output expressions
- Column a > 1
- Column a < 2
- Drag output 1 ( a>1) to destination
- Drag output 2 (a <2) to destination 1
- Complete flow should look like below:
- You are done.
- Run and test.
No comments:
Post a Comment