I create a DTS package and it runs well using the
enterprise manager. But when I put it in schedule, it
fails.
The DTS package will delete some data on the local sql
server and copy some data from the remoter sql server.
Both sql servers services(the sql server agent service and
the sql server service) are running under a domain user
account(kanatek\sqlmanager), which has the administrative
rights. And I also using the same domain user as this
shedule job's owner.

The error message is :
The job failed. The Job was invoked by User
KANATEK\SQLmanager. The last step to run was step 1
(cwangtest)

The process could not be created for step 1 of job
0xF95305C0E8D06C48AC13E9DA84BC2EF2 (reason: The system
cannot find the file specified). The step failed.

I also traced the job execution steps using SQL profiler.
I found that all the LoginNames are KANATEK\SQLmanager.

Please help.
Thanks,
cw

DTS schedule problem
http://support.microsoft.com/default...;EN-US;Q269074
Here you probably find the solution.
Regards,
JFB

"Chengjie" <Chengjie.wang (AT) kanatek (DOT) com> wrote

In addition to this

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

look at this

Service Pack and Version Compatibility Problems
http://www.sqldts.com/default.aspx?6,222,223,0,1


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Has this error been fixed? I am having the same problem.


--
Posted via http://dbforums.com

In article <3242327.1060978555 (AT) dbforums (DOT) com>, DAVIDHWANG
<member23343 (AT) dbforums (DOT) com> writes

Which error? There was a couple of potential solution links posted. can
you describe your error, with the full error message?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com