Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

xp_cmdshell problem

1 view
Skip to first unread message

Antoon

unread,
Jun 10, 2008, 4:26:00 AM6/10/08
to
I'm trying to start a ssis package by using xp_cmdshell.
When I execute the statement it just hangs.

To find the source of the problem I've done the following
exec master.dbo.xp_cmdshell 'dir c\' : no problem
exec master.dbo.xp_cmdshell 'c:\testdir.bat' (where testdir.bat contains an
"mkdir c:\test" command) : no problem

I put the dtexec command with all it's parameters in a testdtexec.bat file
on the server and executed it from the server: no problem

When I then run the command:
exec master.dbo.xp_cmdshell 'c:\testdtexec.bat'
-> a "cmd" process is started (with a user that has admin priv)
-> a "dtexec" process is started (with the same user runs sqlagent)
and then it hangs forever

Any hints would be appreciated

0 new messages