I have a SSIS Data Flow Task with an OleDb Source, Conditional Split (w/ 2 cases), and 2 OleDb Destinations.
Like so...
----------------------------
+--> | Case1: OleDb Destination |
---------------- --------------------- | ----------------------------
| OleDb Source | --> | Conditional Split | --+
---------------- --------------------- | ----------------------------
+--> | Case2: OleDb Destination |
----------------------------
What I want is to guarantee that Case2 only runs on the success of Case1. I know that without doing anything this is highly probable, but I just want to guarantee it.