Hi,
I have an old SQL 2000 server that uses xp_cmdshell. Been working fine for years.
Now it comes up with an error when I run this:
exec master.dbo.xp_cmdshell 'dtsrun -E -Swsisql3 -NImport_APDIST'
I get this error:
Cannot load the DLL ppspps, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
So in troubleshooting I run this:
use master
go
sp_helpextendedproc 'xp_cmdshell'
the results:
name dll
---------------------------
xp_cmdshell ppspps
I can't seem to figure out why the DLL is missing? I searched for ppspps.dll and is not on the server. Is this even the correct file?