Re: Unable to run DTS from SQL Server Agents

#1

This could be an issue like 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

"Paul" <paul.garrad (AT) bt (DOT) com> wrote

Quote:

Hi all

Since going to SP4 on windows 2000 server and loading the
latest Hot Fix SQL2000 KB815495 I've been unable to
succesfully run any agent job that calls a dts package
using the operating system command. The error message that
I receive is 'Executed as user: BTG018472-SQL\SYSTEM. The
process could not be created for step 1 of job
0x126E20290843014188D882C8FF0B5EAD (reason: The system
cannot find the file specified). The step failed.'
The command works from the command prompt, so I know the
file exists and is in the correct location. I've also run
it as a file from the command prompt succesafully but it
will not run from the agent.

I've also scheduled a job from within DTS and then tried
running it from the Agent with exactll the same failure.

Can anybody suggest why these jobs would stop working, is
it a security problem

#2

Thanks for that but this is a single installation running
SQL2000 with the agent directly on the server not through
a client. We've never had SQL7 so I don't think that there
is a compatability problem. None of the DTS packages have
any password.

Quote:

-----Original Message-----
This could be an issue like 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

"Paul" <paul.garrad (AT) bt (DOT) com> wrote in message
news:049b01c35fe6$803af490$a601280a (AT) phx (DOT) gbl...
Hi all

Since going to SP4 on windows 2000 server and loading
the
latest Hot Fix SQL2000 KB815495 I've been unable to
succesfully run any agent job that calls a dts package
using the operating system command. The error message
that
I receive is 'Executed as user: BTG018472-SQL\SYSTEM.
The
process could not be created for step 1 of job
0x126E20290843014188D882C8FF0B5EAD (reason: The system
cannot find the file specified). The step failed.'
The command works from the command prompt, so I know the
file exists and is in the correct location. I've also
run
it as a file from the command prompt succesafully but it
will not run from the agent.

I've also scheduled a job from within DTS and then tried
running it from the Agent with exactll the same failure.

Can anybody suggest why these jobs would stop working,
is
it a security problem

.

#3

The incompatibility would come from, and I am not suggesting this is your
problem, but if I built my packages away fromt he server (DTS is client
side) on 2000 andsaved them to a 7 server then the agent on the 7 server
would run them and have a fit.

Is the problem ONLY for DTS packages ?
What if you use a piece of VBScript to call the package ?
How is the package saved ?
What does your cmd look like ?
If package == on the filesystem then where (Local, Network)?

--

----------------------------
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

"Paul" <paul.garrad (AT) bt (DOT) com> wrote

Quote:

Thanks for that but this is a single installation running
SQL2000 with the agent directly on the server not through
a client. We've never had SQL7 so I don't think that there
is a compatability problem. None of the DTS packages have
any password.

-----Original Message-----
This could be an issue like 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

"Paul" <paul.garrad (AT) bt (DOT) com> wrote in message
news:049b01c35fe6$803af490$a601280a (AT) phx (DOT) gbl...
Hi all

Since going to SP4 on windows 2000 server and loading
the
latest Hot Fix SQL2000 KB815495 I've been unable to
succesfully run any agent job that calls a dts package
using the operating system command. The error message
that
I receive is 'Executed as user: BTG018472-SQL\SYSTEM.
The
process could not be created for step 1 of job
0x126E20290843014188D882C8FF0B5EAD (reason: The system
cannot find the file specified). The step failed.'
The command works from the command prompt, so I know the
file exists and is in the correct location. I've also
run
it as a file from the command prompt succesafully but it
will not run from the agent.

I've also scheduled a job from within DTS and then tried
running it from the Agent with exactll the same failure.

Can anybody suggest why these jobs would stop working,
is
it a security problem

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Unable to run DTS from SQL Server Agents

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Unable to run DTS from SQL Server Agents - 08-11-2003 , 04:13 AM

Re: Unable to run DTS from SQL Server Agents - 08-11-2003 , 04:46 AM

Re: Unable to run DTS from SQL Server Agents - 08-11-2003 , 05:02 AM