Ah, ha. That is one of the requirements (from the article I posted for you) for running Required transaction option in SSIS. You must have MSDTS service running....

Your master proc will catch the error if you raise an error in the child proc. You'll just need your master's catch block to capture and raise the actual...

From your data flow screen shot, it does not appear that any of the data flow is being executed. Your control flow shows the data flow as failing. ...

This data flow is not being executed, what's happening in your Control Flow? Can you give another screen shot of your control flow for the 'Required' option run?

I walked through my example package that I've set up to play with this and it works as expected for me. When the data flow is set to Required...

OK, just so we don't have to go back and forth on this 10 more times, can you get a screen shot of the package execution with the data viewer...

A data viewer is not a transformation. If you double-click on the green arrow prior to the Conditional Split, it will open up the Data Flow Path Editor. ...

Post your table DDL along with a few rows of sample data (readily consumable as described here: http://www.sqlservercentral.com/articles/Best+Practices/61537/.

So, you tested it with your failure condition set to fail (default output) when there are > 50 errors. That worked as expected.

Then, you changed the condition...

Of course not!

I suppose after re-reading your original post, you did say that you're data is comming from a SQL Server DB. You can write a stored...

But I thought you wanted to fail with errors >= 50 not <= 50? Can you post a new screen shot of your current data flow?

Did you write the SSIS package? The package could be ignoring the error for a number of reasons. It could be set up to execute the next task...

This should help: http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx

So you are saying that the rollback is happening correctly for your error condition when there are more than 50 errors?

Are you also saying that it is rolling back when...

Thanks for the feedback.