title: How do I raise an error in an Execute Sql Task in Integration Services?
body: <p>Let me also back up a step - I'm trying to implement a sanity check inside an IS package. The idea is that the entire package runs in a read uncommitted transaction, with the final step being a check that determines that certain row counts are present, that kind of stuff. If they are NOT, I want to raise an exception and rollback the transaction.</p>
  
  <p>If you can tell me how to do this, or, even better, suggest a better way to implement a sanity check, that would be great.</p>