SQL Server Performance Forum – Threads Archive

DTS Job Error (80040E57)

Hi All, 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: "Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:General error -2147217833 (80040E57). Step Error code: 80040E57 Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp Step Error Help Context ID:5300" 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> 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. does anyone have an idea how to solve this. N. Mounir

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

the error I am attaching is from the package Logs so actually these are the details <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> but if it helps more, this error message is from the Job history Step Details Executed as user: ETO-FT-DATA-PSYSTEM. …: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: 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… Process Exit Code 2. The step failed. 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 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. N. Mounir

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

What is the service pack level on SQL Server>
KBA for reference:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/884012 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.

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

mine too is service pack 4 N. Mounir

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.

]]>