This may be a little obscure, but I'm hoping some else has run across this...
I download files from an external FTP site that are encrpyted using PGP. So after I download them I need to run the command line PGP utility to decrypt them. It works fine.
Here's the problem... I am trying to automate this process a little by using XP_CMDSHELL. But when I enter the PGP command line in XP_CMDSHELL that I use in DOS, it doesn't work! It basically gives me an invalid password error. This happens if I issue the command directly through xp_cmdshell or if I use xp_cmdshell to call an external batch file with the pgp commands in it. I also have the same problem if I call the batch file through a CmdExec job step.
It's very strange...
I'm hoping against hope, but has anyone else experience this?
Thanks!
Craig
I download files from an external FTP site that are encrpyted using PGP. So after I download them I need to run the command line PGP utility to decrypt them. It works fine.
Here's the problem... I am trying to automate this process a little by using XP_CMDSHELL. But when I enter the PGP command line in XP_CMDSHELL that I use in DOS, it doesn't work! It basically gives me an invalid password error. This happens if I issue the command directly through xp_cmdshell or if I use xp_cmdshell to call an external batch file with the pgp commands in it. I also have the same problem if I call the batch file through a CmdExec job step.
It's very strange...
I'm hoping against hope, but has anyone else experience this?
Thanks!
Craig