Hello,
I've SQL2000 Standard Edition running on Win2003 server.
I am working with a DTS that was created by a third party software
company. This DTS copys informtion from an iSeries application into a
SQL application. DTS runs fine when I
open in E.M. and execute it also works fine when I save it as a Local
package and then execute it using E.M. But when I scheduled it, it
fails with following error;

Step 'DTSStep_DTSCreateProcessTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:The system cannot find the file specified.
(Microsoft Data Transformation Services (DTS) Package (80070002): The
system cannot find the file specified.
)
Step Error code: 80070002
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100


I read article #269074 from Microsoft, sa is the owner of the job and I
have changed the SQL Server Agent to use my account but I still get the
same error.
The file that this step is looking for is MapicsIFMDelta.exe and it is
located on d:\.

Any suggestions????????????

Lorrie

LWeiss wrote:
I am having a similar problem that just started last week. The error is not that SQL Agent can't find a file, but that
it can't open the DTS package. If the package has an FTP task in it, it can't be opened on the server, either when SQL
Agent tries to open it or if I log on to the server and try to open the package in EM. This happens on all five of my
SQL Server 2000 servers, four on Windows 2000 Advanced Server and one on Windows Server 2003. Packages without an FTP
task have no problems.

U have not called MS yet, since I am still investigating, but I think it is somehow connected to last week's October
updates. My PC has the updates, but the servers do not have them yet.

If I edit the package from EM on my machine and save the package to the server without the FTP task, I can open it in EM
on the server. I can then add the FTP task, save the package on the server and SQL Agent can open and run it.

I am installing the October updates on one of the servers tonight to see if that will fix the problem.

If it is indeed related to the patches, I don't understand why patching my PC has any affect on opening the package on
the server.

Ed

I am successful if I run the DTS Package through E.M, it only fails
when I run it through the scheduler.

Lorrie

"LWeiss" wrote:

I called MS about my problem and it was caused by mis-matched version of
custtask.dll, which is used by EM. The FTP task code is in this dll. My PC
had a newer version than the dll file on the server. They have other
incidents of this in their bug base.

I replaced my file with the same one as on the server and now I can open and
run the package on the server. The file in question is:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\custtask.dll

Hello,

I guess the file location (your d:/) is not known by your SQL server.
To check it : in the query analyser try something like :
EXEC xp_cmdshell 'DIR d:\*.*'

If your expected file is in the resulting list, the problem is somewhere
else.
If not, try replacing your notation d: by some UNC path.

regards

LWeiss a écrit :