Unfortunately no improvement. I tried using both an ODBC connection and an OLE DB connection to Interbase, both failed when scheduled but succeeded when run through SEM.

THe OLE DB connection returned the following error:

• Step Error Source: LCPI.IBProvider.2

  Step Error Descriptionatabase connection failed.

  SQLCODE=-904:

  unavailable database

  IBCODE=isc_unavailable

• Step Error code: 80004005

  Step Error Help File:

  Step Error Help Context ID:0

Interbase / MS SQL Server / DTS don't seem to be a popular mix based upon a few searches through google and the forums... perhaps this is why.