I have a DTS with the Source being ORACLE and the Destination being SQL. When I schedule the package it fails with the following error, "HResult of 0x80004005(-2147467259) returned. Unexpected error occured. An error result was returned without an error message". When I run the package manually I have to double click the ODBC connection a few times and clcik OK to accept the error message and after a few times I can connect and then execute the package. Any suggestions?