Hello,
I've SQL2000 Standard Edition running on Win2K server.
A DTS has two VB app and execute it with a parameter. DTS runs fine when I
open in E.M. and execute it. 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 tried to search some article from web, don't see any thing like my case.
It is not a permission error since other developer can do same thing as I do.
We do not want to run it manually daily basis. Our goal here is scheduled
it to run.

Can any one point out for me?
Thanks in advance

SangHun Jung

Just because you and the developer can run it does not mean it will run when
scheduled.

You may be seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)


remember DTS is a client application

So have a read of this

http://support.microsoft.com/?kbid=269074

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"SangHunJung" <SangHunJung (AT) discussions (DOT) microsoft.com> wrote