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 Descriptionatabase connection failed.
SQLCODE=-904:
unavailable database
IBCODE=isc_unavailable
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.