Groups | Blog | Home
all groups > sql server dts > may 2005 >

sql server dts : Schedule Error CmdExec


Helge C. Rutz
5/6/2005 12:00:00 AM
Hi Flora,

"Flora Pho" <FloraPho@discussions.microsoft.com> schrieb im Newsbeitrag
news:DB4D5ABA-690E-47C8-9178-44CBD0937195@microsoft.com...
[quoted text, click to view]

because the normal errors caused by misconfiguration or security related
issues are very specific reported, saying exactly whats wrong, I think this
goes more to the dll hell direction.
Running the Task manually in Designer is something totally different, as
long as you run the designer on a different machine.
Is Admin also member of the sysadmin role, or did you configured the proxy
account?
Have you ever used CmdExec before? Have you changed anything, apllied SPs
or something like that?
What OS do you use for the Server?

Helge

Flora Pho
5/6/2005 5:08:06 AM
Hi,

I schedule a DTS package that runs manually, it's executed on the server
The owner of the package is Admin
The owner of the task is also Admin
And Admin is owner of the DataBase group
But the schedule task returns me the error:
"cannot be run because the CmdExec subsystem failed to load. The job has
been suspended"

How can i solve this problem ?
And how can i re-run the suspended task ?

Rgds
Flora.

Helge C. Rutz
5/6/2005 3:55:55 PM
Hi Flora,

"Helge C. Rutz" <news050424@nurfuerspam.de> schrieb im Newsbeitrag
news:3e1ai7FmorrU1@individual.net...
[quoted text, click to view]

maybee this article is a hint?
http://support.microsoft.com/default.aspx?scid=kb;en-us;315005

Helge

Flora Pho
5/9/2005 2:31:10 AM
I checked for the dll direction and it's ok
But i never use CmdExec before
How does it be configure ?

[quoted text, click to view]
Jim Vierra
5/9/2005 11:40:36 AM
Here is the latest MDAC component checker. It reports on the version and
installation status of all versions of MDAC.

http://www.microsoft.com/downloads/details.aspx?FamilyID=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en


--
Jim Vierra

[quoted text, click to view]

AddThis Social Bookmark Button