'Are you sure it's not working? It was working just fine on my computer.' Sound familiar?
Errors are a part of production, but when going from development to production under a time crunch, you simply may not have the time or the workforce to go back and search through endless SQL statements and data flows. Maybe a SQL statement changed, or maybe your connection manager was altered, but what if it was something so small, it is almost impossible to find?