DTS Executing Mannual Error Thru Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Executing Mannual Error Thru Job

Hi All, There is already created a DTS on Production Box. This job is getting execute success when starts manually. But the job scheduled for this job does’nt executing and it is showing the error
"Executed as user: NXCLMNF4SYSTEM. DTSRun: Loading… DTSRun: Executing… DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed." FYI
The SQL Server Agent configured as Local.
The DTS Owner ID does not exist in Domain Directory.
The Job owner is the different and this ID has the SA rights.
The data being fetched from Oracle box and getting transferred to SQL Server. My question is only why the DTS is running success if it executed manually and when executed thru Job it getting failed. Thanks in Advance, Shekhar "No passion in the world is equal to the passion to alter someone else’s draft."
There are many posts with similar problem, refer tohttp://support.microsoft.com/kb/269074 for further actions. Enable the DTS package logging to see whereit is failing. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Check the permision of your SQL Server agent —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
]]>