I have a job which transforms data from Oracle to SQL. It
works perfectly if I run it in DTS. However, it returns an
error if I scheduled it to run in the scheduler. The
error indicates that the Oracle client and networking
components were not found. However, the Oracle client and
the networking compenents are in fact installed on the
server already. That's how I am able run the job
successfully inside the DTS on the server. I thought it
could be related to the right of the executed user in the
scheduler. I tried different things but it still does not
work. Any suggestions/insights are greatly
appreciated!!!!!

Error listed:
Executed as user: Domain\SQLServerAdministrator. ...t:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005) Error string: Oracle client and
networking components were not found. These components are
supplied by Oracle Corporation and are part of the Oracle
Version 7.3.3 or later client software installation.
Provider is unable to function until these components are
installed. Error source: Microsoft OLE DB Provider
for Oracle Help file: Help context: 0
Error Detail Records: Error: -2147467259 (80004005);
Provider Error: 0 (0) Error string: Oracle client
and networking components were not found. These components
are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software
installation. Provider is unable to function until
these components are in... Process Exit Code 1. The step
failed.

Thanks.

When you schedule it then it runs at the scheduling server. You need to
make sure you have the Oracle connectivity components on that box.

Also

INF: How to Run a DTS Package as a Scheduled Job
PSS ID Number: Q269074
Article Last Modified on 09-25-2002


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"SPC" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I checked, they indeed are installed on that box. Any
other suggestions?

Thanks.

Then they are not visible to the SQL Server Agent or Proxy Account.

try logging in to the server as the SQL Server Account and Executing the
package manually

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


<anonymous (AT) discussions (DOT) microsoft.com> wrote