I had the same problem with a package in SQL 7.0 using a Interbase ODBC connection.

The packed executed ok when a ran it manually, but when I scheduled it it...