We have recently migrated to windows 2003 server. The oracle client is also installed on this server .We have a DTS which pulls data from an oralce 9.2 server. The DTS runs fine by itself ( we remoted into the server and ran it on the server). However when we schedule it is a job or try running it in Query analyser with xp_cmdshell it gives anerror "DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC driver for Oracle][Oracle]
Error source: Microsoft OLE DB Provider for ODBC Drivers"
The permissions on the oracle home etc look fine .. The id under which job is run has system admin level permissions.
Can anyone please help!!
Thx