I have a package which will tranform a data from one table to another. In case if there is an errror on a records it will dump that error on flat file, and if error exceeds more than 50 then the entire packagae should fail. I used conditional split by creating variable rowcount, but when error exceeds more than 50 my package doesnt fail instead it will copy all the errors which are more than 50 on a flat file. do any one have an idea to fail a package if the condition doesnt meet.
I have attahced a screnshot of my dataflow.