Tuesday, January 18, 2011

SSIS SQL 2008 Data Flow continues even after failure

How is this possible? One step fails (Red box), but it still goes and does the next step (The “Finished” box), even though it is conditional upon the successful completion of the previous step (indicated by the Green arrow)!!!