Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.
Skipping insertion of a row
DTS allowed us to skip processing of a row by use of 'DTSTransformStat--SkipInsert' in an ActiveX Script. This would mean that the row would not get inserted into the destination.
In SSIS, we talk of filtering rows rather than skipping them. The Conditional Split transform has multiple outputs and can direct an incoming row down one of those outputs depending on whether an expression upon values in the row evaluates to true or false. If a row is directed to an output that is not used downstream then that row will not arrive at a destination - effectively 'skipped'.