SQL Server Performance

DTS Executing Mannual Error Thru Job

Discussion in 'SQL Server DTS-Related Questions' started by shekhar157, Jun 22, 2007.

  1. shekhar157 New Member

    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."

  2. satya Moderator

    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.
  3. dineshasanka Moderator

    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/

Share This Page