SSIS Basics: Conditional splits
SSIS is probably one of the most non-intuitive GUIs I've ever seen from Microsoft, and it appears to be broken in many interesting ways. Despite this frustration, the functionality it provides is indispensable. This page will document how to perform a simple conditional split.