I have created a package that imports One table from Oracle.
If i run this Package in DTS DEsigner...it runs fine, but when i schedule
it, the job failes

The execution of the following DTS Package succeeded:

Package Name: DataMart Import (Oracle)
Package Description: Imports Tables From Oracle Data Ware House
Package ID: {D325F646-F3EB-479E-9F55-C80EFD22F2F3}
Package Version: {C4A77964-4ECD-451F-8EA8-B07F0EBD3D72}
Package Execution Lineage: {DD61A3C2-C841-4E72-9A89-23EDF311C6F3}
Executed On: USROC-SQL1
Executed By: ROCDMSQLAgent
Execution Started: 10/26/2005 1:34:23 PM
Execution Completed: 10/26/2005 1:34:23 PM
Total Execution Time: 0.015 seconds

Package Steps execution information:


Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Class not registered
(Microsoft Data Transformation Services (DTS) Package (80040154): Class not
registered
) (Microsoft OLE DB Service Components (80040154): Class not registered)
Step Error code: 80040154
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Step Execution Started: 10/26/2005 1:34:23 PM
Step Execution Completed: 10/26/2005 1:34:23 PM
Total Step Execution Time: 0.015 seconds
Progress count in Step: 0
************************************************** **************************************************


Any ideas ?

If the SQLAgent Account is a member of the local admins group the job runs
fine, if not it failes. I would prefer to keep the Agent account out of the
local admins.....what object/permissions is stopping me from running w/o
admin privs ?


"David J. Cartwright" <davidcartwright (AT) hotmail (DOT) com> wrote