The particular problem that I'm documenting is an SSIS package that runs until it's data source shuts down for a restore, each hour.

The feed, which supplies us data that would run for many hours if allowed, goes down from :00 to :20 each hour for restore.  It is near real time, but it is the only way to get the data needed.