SQL Server Performance

DTS Job Error (80040E57)

Discussion in 'SQL Server DTS-Related Questions' started by Nancy, Apr 12, 2007.

  1. Nancy New Member

    Hi All,<br />I have a DTS package when I run it for the Enterprise manager, it is successful, but when I schedule it as a Job it fails with the following Error:<br /><br /><b>"Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:General error -2147217833 (80040E57).<br />Step Error code: 80040E57<br />Step Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp<br />Step Error Help Context ID:5300"</b><br /><br />I searched Microsoft articles and found the following article <a href='"http://support.microsoft.com/kb/269074/en-us"' target='_blank' title='"http://support.microsoft.com/kb/269074/en-us"'<a target="_blank" href=http://support.microsoft.com/kb/269074/en-us>http://support.microsoft.com/kb/269074/en-us</a>)</a><br /><br />based on this article it says that this a security issue with the account used for the SQLServerAgent . so I changed SQLServerAgent account to use the 'Sa' login, which I thought should have full authority to run the DTS from a Job. but I am still receiving the same error. <br />does anyone have an idea how to solve this.<br /><br />N. Mounir
  2. 7013d0 New Member

    Hi Nancy!
    Is there any other error message on the job history? Then try marking the "Show step details" checkbox (if you haven't marked yet) and look for messages for Step# > 0.
    Also, what the DTS is doing? Importing/exporting files? Transferring data between servers?

    Regards,

    Fernando Toledo
  3. Nancy New Member

    the error I am attaching is from the package Logs so actually these are the details <img src='/community/emoticons/emotion-1.gif' alt=':)' /> <br />but if it helps more, this error message is from the Job history Step Details<br /><b>Executed as user: ETO-FT-DATA-PSYSTEM. ...: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: <br />DTSStep_DTSExecuteSQLTask_1, Error = -2147217833 (80040E57) Error string: General error -2147217833 (80040E57). Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 5300 Error Detail Records: Error: -2147217833 (80040E57); Provider Error: 0 (0) Error string: General error -2147217833 (80040E57). Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 5300 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSE... <br />Process Exit Code 2. The step failed.</b><br /><br />It is actually an 18 SQL Tasks DTS, used for reporting purposes, reading data from Multiple database and putting them all in 1 reporting Table <br />this is the first step in the DTS, the other 17 steps are running fine, the only difference is that this step contains a join between 2 tables each of them on a separate DB, so using Full Qualified names.<br /><br /><br />N. Mounir
  4. sql_er New Member

    I have a similar problem:

    I have a DTS package, running accross a few servers (copying over data from tables in 1 server into tables of another server). I created a job to run it automatically once a week. When I run this DTS package manually, it runs with no problem. When the job executes (running this dts package), I get the following error:

    Executed as user: AJJcust. ...OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, 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_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147467259 (80004005) Error... Process Exit Code 3. The step failed.

    Could anyone suggest the possible solution? It looks like there is login issue, but why would that only be a problem when the job is executing the DTS package and how can I fix it?


    Please let me know

    Thank you
  5. satya Moderator

  6. sql_er New Member

    It is service pack 4. Below is what I get with SELECT @@VERSION:

    Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    And

    SELECT SERVERPROPERTY('productversion')

    SELECT SERVERPROPERTY('productlevel')

    return 8.00.2040 and SP4, respectively


    Thanks

  7. Nancy New Member

    mine too is service pack 4

    N. Mounir
  8. satya Moderator

    Check the KBA links above about performing DTS as a scheduled ob.

    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. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page