I know the SQL is prepared for every known bad situation, but it still fails.

I've seen lot of situations where the package should not fail and it does. ...

Very nice article.

I remember one of my production databases went to SUSPECT, basically the drive where the data/log files were located ran out of space.

Basically I released space, stopped-started the...

Strongly recommend you to run a logical and physical check on your drives. it may lead to disk issues. 😉

too much posts.

but try this  in the queries :