I have a DTS package that will run fine in almost every place except when
it's scheduled. I can right-click on the package and select "Execute" and
it runs ok. I can open the package in design view and run it, and it's ok.
I can open up a command prompt on the server and run dtsrun and it runs ok,
but the scheduled job fails. The job also fails if I try and manually run
the job by right-clicking on the job and selecting "start job"

I have logging enabled on the the package. All of the activex tasks run
fine, but any of the datapump tasks fail with the following error:

Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:Specified driver could not be loaded due to system
error 126 (Oracle73 Ver 2.5).
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0

The datapump tasks are copying data from an Oracle DB server to my SQL
Server 2000 machine.

Thanks

In message <#8jxq6gDFHA.2804 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Travis Sharpe
<user (AT) anon (DOT) com> writes
Scheduling normally causes a change in execution location and context.
Make sure the driver is correctly installed on the server and is
available for the SQL Server Agent service account.

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/kb/q269074/)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org